#!/usr/bin/env python
# coding:utf-8


"""
字段映射关系
"""


InstitutionsCompanyMap = {
    'announcement_date': 'PUBLISHDATE',
    'org_type': 'COMPTYPE2',
    'org_name': 'COMPNAME',
    'org_sname': 'COMPSNAME',
    'org_ename': 'ENGNAME',
    'org_espell': 'ENGSNAME',
    'org_capital': 'REGCAPITAL',
    'currency_type': 'CUR',
    'build_time': 'FOUNDDATE',
    'com_nature': 'ORGTYPE',
    'regist_add': 'REGADDR',
    'office_add': 'OFFICEADDR',
    'org_web': 'COMPURL',
    'nati_name': 'COUNTRY',
    'total_staff': 'WORKFORCE',
    'legal_rp': 'LEGREP',
    'gen_manager': 'MANAGER',
    'contact_tel': 'COMPTEL',
    'contact_fax': 'COMPFAX',
    'office_postcode': 'OFFICEZIPCODE',
    'email': 'COMPEMAIL',
    'org_profile': 'COMPINTRO',
    'main_business': 'MAJORBIZ',
    'start_date': 'EXISTBEGDATE',
    'cutoff_date': 'EXISTENDDATE',
    'busi_mainscope': 'BIZSCOPE',
    'acc_firm': 'ACCFIRM',
    'law_firm': 'LECONSTANT',
    'come_source': 'COME_SOURCE',
    'source_id': 'COMPCODE',
    'domestic_listing': 'ISLIST',
    'secretary': 'BSECRETARY',
    'secretary_tel': 'BSECRETARYTEL',
    'secretary_rep': 'SEAFFREPR',
    'board_chair_man': 'CHAIRMAN'
}

InstitutionsFundMap = {
    'org_name': 'SENAME',
    'come_source': 'COME_SOURCE',
    'org_type': 'ORG_TYPE',
}

FundSecuritiesMap = {
    'com_uni_code': 'COMPCODE',
    'sec_name': 'SESNAME',
    'sec_fname': 'SENAME',
    'sec_code': 'SYMBOL',
    'abc_code': 'ABC_CODE',
    'sec_small_type': 'SETYPE',
    'sec_short_name': 'SESPELL',
    'ipo_status': 'LISTSTATUS',
    'security_type': 'EXCHANGE',
    'ipo_date': 'LISTDATE',
    'end_date': 'ENDDATE',
    'currency_type': 'CUR',
    'come_source': 'come_source',
    'sec_type': 'sec_type',
    'ipo_sector': 'ipo_sector',
    'source_id': 'SECURITYID',
}

FundInfoMap = {
    'sec_uni_code': 'SECURITYID',
    'announcement_date': 'UPDATEDATE',
    'fund_name': 'FDNAME',
    'fund_sname': 'FDSNAME',
    'fund_type': 'FDTYPE',
    'fund_method': 'FDMETHOD',
    'investment_style': 'INVESTSTYLE',
    'mana_uni_code': 'KEEPERNAME',
    'cust_uni_code': 'TRUSTEENAME',
    'exsit_period': 'EXSITPERIOD',
    'operate_period': 'OPERATEPERIOD',
    'operate_period_unit': 'OPERATEPERIODUNIT',
    'unit_par_value': 'ISSUEPARVALUE',
    'issue_mode': 'ISSUEMODE',
    'issue_price': 'UNITISSPRICE',
    'issue_fee': 'UNITISSFEE',
    'invst_cur_type': 'CUR',
    'coll_amut_upper': 'EXPISSTOTSHARE',
    'iss_beg_date': 'ISSBEGDATE',
    'iss_end_date': 'ISSENDDATE',
    'is_valid': 'ISVALID',
    'is_stat': 'ISSTAT',
    'sub_type': 'SUBTYPE',
    'pay_type': 'PAYTYPE',
    'spon_sub_pla_amt': 'SPONSUBPLAAMT',
    'insu_sub_pla_amt': 'INSUSUBPLAAMT',
    'pub_sub_pla_amt': 'PUBSUBPLAAMT',
    'pub_sub_tot_share': 'PUBSUBTOTSHARE',
    'issue_sub_ratio': 'SUBRTO',
    'issue_frozen_capital': 'EFFFREFD',
    'issue_success_rate': 'ISSUESUCRATE',
    'valid_sub_num': 'EFFSUBNUM',
    'valid_sub_share': 'TOTALFFERFD',
    'coll_val_inti': 'OFFERINTE',
    'total_coll_share': 'TOTAL_COLL_SHARE',
    'initiator_sub_share': 'SPOSUBTOTSHARE',
    'fund_found_date': 'FOUNDDATE',
    'fund_end_date': 'EXISTENDDATE',
    'out_app_start_date': 'OUTSUBBEGDATE',
    'out_redem_start_date': 'OUTSUBENDDATE',
    'in_app_start_date': 'INSUBBEGDATE',
    'in_redem_start_date': 'INREDENDDATE',
    'sub_conf_date': 'SUBCONFDATE',
    'redem_conf_date': 'REDCONFDATE',
    'redem_pay_date': 'REDPAYDATE',
    'fund_list_date': 'LISTDATE',
    'exchange': 'EXCHANGE',
    'list_share': 'LISTCIRCAMT',
    'nav_pub_type': 'NAVPUBTYPE',
    'invst_target': 'INVESTGOAL',
    'invst_rule': 'INVRULE',
    'invst_orient': 'INVESTRANGE',
    'risk_type': 'RISKTYPE',
    'invst_stra': 'INVESTPOLICY',
    'decision_rule': 'DECISIONRULE',
    'large_redem_treat': 'HUGEREDEPLAN',
    'profit_dist_rule': 'DISTRIBUTPRIN',
    'remark': 'MEMO',
}

FundBenchMarkMap = {
    'sec_uni_code': 'SECURITYID',
    'begin_date': 'BEGINDATE',
    'end_date': 'ENDDATE',
    'fund_benchmark': 'PERBENMARK',
    'yield_period': 'YIEPERIOD',
    'is_valid': 'ISVALID',
    'memo': 'MEMO',
}

FundNavMap = {
    'sec_uni_code': 'SECURITYID',
    'announcement_date': 'PUBLISHDATE',
    'end_date': 'NAVDATE',
    'currency_type': 'CUR',
    'unit_nav': 'UNITNAV',
    'cumu_unit_nav': 'ACCUNITNAV',
    'grow_line_value': 'GROWLINEVALUE',
    'asset_nav': 'ASSETNAV',
    'rise_rate': 'GROWRATE',
    'is_exdiv_date': 'ISEXDIVDATE',
    'memo': 'MEMO',
}

FundNavCurMap = {
    'sec_uni_code': 'SECURITYID',
    'announcement_date': 'PUBLISHDATE',
    'begin_date': 'BEGINDATE',
    'end_date': 'ENDDATE',
    'special_sign': 'SPECIALSIGN',
    'ten_thousand_returns': 'MILLIONGAIN',
    'seven_day_yield': 'SEVENDAYYIELD',
    'ten_thousand_cumu_returns': 'MILCUMUGAIN',
    'asset_nav': 'ASSETNAV',
    'announced_returns': 'ANNOUNCEDGAIN',
    'announced_returns_unit': 'UNIT',
    'is_stat': 'ISSTAT',
    'memo': 'MEMO'
}

FundNavBenchmarkMap = {
    'sec_uni_code': 'SECURITYID',
    'announcement_date': 'PUBLISHDATE',
    'begin_date': 'BEGINDATE',
    'end_date': 'ENDDATE',
    'report_type': 'REPORTTYPE',
    'stat_period': 'STATPERIOD',
    'nav_growth_rate': 'NAVGRORATE',
    'nav_growth_stdev': 'NAVGRORATESTA',
    'benchmark_growth_rate': 'PERBENMARKRATE',
    'benchmark_growth_rate_stdev': 'PERBENMARKRATESTA',
    'growth_rate_dif': 'FIELDDIF',
    'stdev_dif': 'STANDEVIDIF',
    'memo': 'MEMO'
}

PlateInfoMap = {
    'sec_uni_code': 'SECURITYID',
    'org_uni_code': 'SECURITYID',
    'begin_date': 'BEGINDATE',
    'end_date': 'ENDDATE',
    'plate_code': 'CLASSCODE',
    'is_valid': 'ISVALID',
}

FundRateMap = {
    'sec_uni_code': 'SECURITYID',
    'announcement_date': 'PUBLISHDATE',
    'begin_date': 'BEGINDATE',
    'end_date': 'ENDDATE',
    'rate_type1': 'RATENAME1',
    'rate_type2': 'RATENAME2',
    'serial_number': 'NUMBER',
    'rate_calc_mode': 'COSTCALCMODE',
    'currency_type': 'CUR',
    'rate_unit': 'RATECOSTUNIT',
    'rate_min_cost': 'RATEMINCOST',
    'rate_relationship': 'RATERESH',
    'rate_max_cost': 'RATEMAXCOST',
    'app_min_amount': 'APPMINAMT',
    'amount_relationship': 'APPAMTRESH',
    'app_max_amount': 'APPMAXAMT',
    'hold_period_unit': 'HOLDPERUNIT',
    'hold_min_period': 'HOLDMINPERIOD',
    'hold_period_relationship': 'HOLDPERRESH',
    'hold_max_period': 'HOLDMAXPERIOD',
    'app_object': 'APPOBJECT',
    'is_valid': 'ISVALID',
    'remark': 'MEMO',
}

ClosedFundInfoMap = {
    'sec_uni_code': 'SECURITYID',
    'announcement_date': 'PUBLISHDATE',
    'expo_announcement_date': 'NTLETPUBDATE',
    'expo_issue_beg_date': 'ISSBEGDATE',
    'expo_issue_end_date': 'ISSENDDATE',
    'be_iss_tot_share': 'BEISSTOTSHARE',
    'expo_tot_share': 'UNITTOTSHARE',
    'expo_issue_fee': 'UNITISSFEE',
    'expo_ratio': 'EXPORATIO',
    'expo_record_date': 'RECORDDATE',
    'expo_exright_base_date': 'EXRIGHTBASDATE',
    'expo_fund_list_date': 'LISTDATE',
    'expo_exchange': 'EXCHANGE',
    'expo_list_share': 'LISTCIRCAMT',
    'spon_sub_pla_amt': 'SPONSUBPLAAMT',
    'insu_sub_pla_amt': 'INSUSUBPLAAMT',
    'pub_sub_pla_amt': 'PUBSUBPLAAMT',
    'pub_sub_tot_share': 'PUBSUBTOTSHARE'
}

GuaranteedFundInfoMap = {
   'sec_uni_code': 'SECURITYID',
   'guaranteed_fee_rate': 'SECURITYID1',
   'warrantor': 'SECURITYID1'
}

GuaranteedFundCycleMap = {
    'sec_uni_code': 'SECURITYID',
    'announcement_date': 'DECLAREDATE',
    'date_type': 'DTYPE',
    'begin_date': 'BEGINDATE',
    'end_date': 'ENDDATE',
    'remark': 'MEMO',
}

ETFBasicInfoMap = {
    'sec_uni_code': 'SECURITYID',
    'onl_cash_offering_code': 'SECURITYID1',
    'app_redem_code': 'SECURITYID1',
    'app_redem_sname': 'SECURITYID1',
    'exchange_code': 'SECURITYID1',
    'exchange_sname': 'SECURITYID1',
    'onl_cash_sub_start_date': 'SECURITYID1',
    'onl_cash_sub_end_date': 'SECURITYID1',
    'onl_cash_sub_lower': 'SECURITYID1',
    'onl_cash_sub_upper': 'SECURITYID1',
    'offl_cash_sub_start_date': 'SECURITYID1',
    'offl_cash_sub_end_date': 'SECURITYID1',
    'offl_cash_sub_lower': 'SECURITYID1',
    'offl_sec_sub_start_date': 'SECURITYID1',
    'offl_sec_sub_end_date': 'SECURITYID1',
    'offl_sec_sub_lower': 'SECURITYID1',
    'list_date': 'LISTDATE',
}

LOFBasicInfoMap = {
    'sec_uni_code': 'SECURITYID',
    'announcement_date': 'DECLAREDATE',
    'list_date': 'LISTDATE',
}

MoneyMarketFundBasicInfoMap = {
    'sec_uni_code': 'SECURITYID',
    'announcement_date': 'DECLAREDATE',
    'profit_pay_type': 'PROFITPAYTYPE',
    'share_tras_type': 'TRASTYPE',
    'share_tras_date': 'EMONOVERDATE',
}

FundPriceDayMap = {
    'sec_uni_code':	'SECURITYID',
    'sec_code':	'SYMBOL',
    'sename': 'SENAME',
    'trade_date': 'TRADEDATE',
    'exchange':	'EXCHANGE',
    'pre_close_price': 'LCLOSE',
    'open_price': 'TOPEN',
    'close_price': 'TCLOSE',
    'high_price': 'THIGH',
    'low_price': 'TLOW',
    'volume': 'VOL',
    'amount': 'AMOUNT',
    'trade_num': 'DEALS',
    'avg_price': 'AVGPRICE',
    'avg_vol': 'AVGVOL',
    'avg_amount': 'AVGTRAMT',
    'differ': 'CHANGE',
    'differ_range': 'PCHG',
    'amplitude': 'AMPLITUDE',
    'turnover_rate': 'TURNRATE',
    'discount_rate': 'DISCOUNTRATE',
}

FundPriceWeekMap = {
    'sec_uni_code': 'SECURITYID',
    'sec_code': 'SYMBOL',
    'sename': 'SECURITYID',
    'trade_date': 'TRADEDATE',
    'exchange': 'EXCHANGE',
    'pre_close_price': 'LCLOSE',
    'open_price': 'TOPEN',
    'close_price': 'TCLOSE',
    'high_price': 'HIGH',
    'low_price': 'LOW',
    'high_close_price': 'HTCLOSE',
    'low_close_price': 'LTCLOSE',
    'avg_price': 'AVGPRICE',
    'differ': 'CHG',
    'differ_range': 'PCHG',
    'avg_differ_range': 'AVGPCHG',
    'turnover_rate': 'TURNOVER',
    'avg_turnover_rate': 'AVGTURNOVER',
    'volume': 'VOTURNOVER',
    'amount': 'VATURNOVER',
    'amplitude': 'PRANGE',
    'avg_discount': 'AVGDISCOUNTW',
    'avg_discount_rate': 'AVGDISCOUNTRATEW',
    'high_price_date': 'HTRADEDATE',
    'low_price_date': 'LTRADEDATE',
    'high_close_price_date': 'HTTRADEDATE',
    'low_close_price_date': 'LTTRADEDATE',
}

FundPriceMonthMap = {
    'sec_uni_code': 'SECURITYID',
    'sec_code': 'SYMBOL',
    'sename': 'SECURITYID',
    'trade_date': 'TRADEDATE',
    'exchange': 'EXCHANGE',
    'pre_close_price': 'LCLOSE',
    'open_price': 'TOPEN',
    'close_price': 'TCLOSE',
    'high_price': 'HIGH',
    'low_price': 'LOW',
    'high_close_price': 'HTCLOSE',
    'low_close_price': 'LTCLOSE',
    'avg_price': 'AVGPRICE',
    'differ': 'CHG',
    'differ_range': 'PCHG',
    'avg_differ_range': 'AVGPCHG',
    'turnover_rate': 'TURNOVER',
    'avg_turnover_rate': 'AVGTURNOVER',
    'volume': 'VOTURNOVER',
    'amount': 'VATURNOVER',
    'amplitude': 'PRANGE',
    'avg_discount': 'AVGDISCOUNTM',
    'avg_discount_rate': 'AVGDISCOUNTRATEM',
    'high_price_date': 'HTRADEDATE',
    'low_price_date': 'LTRADEDATE',
    'high_close_price_date': 'HTTRADEDATE',
    'low_close_price_date': 'LTTRADEDATE',
}

FundPriceYearMap = {
    'sec_uni_code': 'SECURITYID',
    'sec_code': 'SYMBOL',
    'sename': 'SECURITYID',
    'trade_date': 'TRADEDATE',
    'exchange': 'EXCHANGE',
    'pre_close_price': 'LCLOSE',
    'open_price': 'TOPEN',
    'close_price': 'TCLOSE',
    'high_price': 'HIGH',
    'low_price': 'LOW',
    'high_close_price': 'HTCLOSE',
    'low_close_price': 'LTCLOSE',
    'avg_price': 'AVGPRICE',
    'differ': 'CHG',
    'differ_range': 'PCHG',
    'avg_differ_range': 'AVGPCHG',
    'turnover_rate': 'TURNOVER',
    'avg_turnover_rate': 'AVGTURNOVER',
    'volume': 'VOTURNOVER',
    'amount': 'VATURNOVER',
    'amplitude': 'PRANGE',
    'avg_discount': 'AVGDISCOUNTY',
    'avg_discount_rate': 'AVGDISCOUNTRATEY',
    'high_price_date': 'HTRADEDATE',
    'low_price_date': 'LTRADEDATE',
    'high_close_price_date': 'HTTRADEDATE',
    'low_close_price_date': 'LTTRADEDATE'
}

FundDividendMap = {
    'sec_uni_code': 'SECURITYID',
    'announcement_date': 'PUBLISHDATE',
    'dividend_status': 'DIVIIMPMARKD',
    'default_dividend_type': 'DEFSHAREMODE',
    'dividend_year': 'BONUSYEAR',
    'dividend_serial_number': 'CURYACCBNSAMT',
    'dividend_base_date': 'DISTINCBASEDATE',
    'base_available_profit': 'AVAIDISTINC',
    'base_actual_dividend': 'ACTBONUSAMT',
    'dividend_basic_share': 'BASISSHARE',
    'ten_div_pre_tax': 'UNITPTAXDEV',
    'ten_div_after_tax': 'UNITATAXDEV',
    'record_date': 'RECORDDATE',
    'out_right_date': 'OUTRIGHTDATE',
    'inner_right_date': 'INNERRIGHTDATE',
    'actual_right_date': 'ACTRIGHTDATE',
    'out_dividend_date': 'OUTDEVDATE',
    'inner_dividend_date': 'INNERDEVDATE',
    'div_rein_date': 'TURNREINDATE',
    'rein_pay_date': 'REINPAYDATE',
    'rein_redem_beg_date': 'REINREDBEGDATE',
    'currency_type': 'CUR',
}

MoneyMarketFundDividendMap = {
    'sec_uni_code': 'SECURITYID',
    'announcement_date': 'DECLAREDATE',
    'dividend_year': 'YEAR',
    'dividend_serial_number': 'TIME',
    'dividend_type': 'PAYMODE',
    'acc_beg_date': 'ACCBEGDATE',
    'acc_end_date': 'ACCENDDATE',
    'dividend_pay_date': 'YIELDPAYDATE',
    'dividend_carry_date': 'YEILDCARDATE',
    'record_date': 'RECORDDATE',
    'dividend_off_date': 'BONUSOFFDAY',
    'rein_pay_date': 'REINPAYDATE',
    'rein_redem_beg_date': 'REDEBEGDATE',
}

PeopleBasicInfoMap = {
    'name': 'CNAME',
    'sex_par': 'GENDER',
    'people_char': 'PEOPLE_CHAR',
    'birth_day': 'BIRTHDAY',
    'country': 'NATIONALITY',
    'poli_status': 'PAFFILI',
    'high_edu': 'DEGREE',
    'back_gro': 'MEMO',
    'come_source': 'COME_SOURCE',
    'source_id': 'SOURCE_ID'
}

FundManagerBasicInfoMap = {
    'sec_uni_code': 'SECURITYID',
    'sec_name': 'FDSNAME',
    'peo_uni_code': 'MANAGERCODE',
    'fund_manager_name': 'MANAGERNAME',
    'begin_date': 'BEGINDATE',
    'end_date': 'ENDDATE'
}

InstitutionsChangeMap = {
    'org_uni_code': 'COMPCODE',
    'announcement_date': 'PUBLISHDATE',
    'change_type': 'CHGTYPE',
    'begin_date': 'BEGINDATE',
    'end_date': 'ENDDATE',
    'begin_change': 'BECHG',
    'after_change': 'AFCHG',
    'change_reason': 'CHGEXP',
    'come_source': 'COME_SOURCE',
}

SecuritiesChangeMap = {
    'sec_uni_code': 'SECURITYID',
    'announcement_date': 'PUBLISHDATE',
    'change_type': 'CHANGETYPE',
    'begin_date': 'BEGINDATE',
    'end_date': 'ENDDATE',
    'begin_change': 'BECHG',
    'after_change': 'AFCHG',
    'come_source': 'COME_SOURCE',
}

ETFSubRedemListMap = {
    'sec_uni_code': 'SECURITYID',
    'announcement_date': 'PUBLISHDATE',
    'trade_date': 'TRADEDATE',
    'sub_redem_sec_type': 'SUBCOMPLIST',
    'sec_code': 'SYMBOL',
    'cash_balance': 'CASHBALANCE',
    'unit_min_sub_redem_nav': 'UNITMINSUBNAV',
    'unit_nav': 'NAVSHARE',
    'estimated_cash_amount': 'ESTIMATEDCASH',
    'max_cash_subs_ratio': 'MAXCASHRTO',
    'min_sub_redem_share': 'UNITMINSUB',
    'is_pub_iopv': 'ISPUBIOPV',
    'acc_sub_limit_upper': 'TDACCSUBLIMIT',
    'acc_redem_limit_upper': 'TDACCREDLIMIT',
    'oa_acc_sub_limit_upper': 'OATDACCSUBLIMIT',
    'oa_acc_redem_limit_upper': 'OATDACCREDLIMIT',
    'is_allow_sub': 'ISALLOWSUB',
    'is_allow_redem': 'ISALLOWRED',
}

ETFSRComponentsMap = {
    'fund_uni_code': 'SECURITYID',
    'announcement_date': 'DECLAREDATE',
    'trade_date': 'TRADEDATE',
    'sub_redem_sec_type': 'SUBCOMPLIST',
    'fund_code': 'SYMBOL',
    'sec_uni_code': 'CSYMBOL',
    'sec_code': 'CSYMBOL',
    'sec_name': 'SNAME',
    'sec_quantity': 'STKQUT',
    'cash_substitute_sign': 'CASHREPLACEFLAG',
    'cash_substitute_ratio': 'CASHREPLACERTO',
    'fixed_substitute_amount': 'REPLACEAMT',
}

FundAssetAllocationMap = {
    'sec_uni_code': 'SECURITYID',
    'announcement_date': 'PUBLISHDATE',
    'end_date': 'REPORTDATE',
    'tot_fund_asset': 'TOTFDASSET',
    'tot_fund_nav': 'TOTFDNAV',
    'tot_fund_nav_cla': 'TOTFDNAVCLA',
    'equ_inv_value': 'EQUITYINVEMKTCAP',
    'equ_net_ratio': 'EQUITYINVERTO',
    'stk_inv_value': 'SKMKTCAP',
    'stk_net_ratio': 'SKRATIO',
    'dep_inv_value': 'DRMKTCAP',
    'dep_net_ratio': 'DRRTO',
    'est_inv_value': 'REITSMKTCAP',
    'est_net_ratio': 'REITSRTO',
    'fixed_inv_value': 'FIXEDMKTCAP',
    'fixed_net_ratio': 'FIXEDRTO',
    'bond_inv_value': 'BDMKTCAP',
    'bond_net_ratio': 'BDRTO',
    'natl_bond_value': 'NDMKTCAP',
    'natl_bond_net_ratio': 'NDRTO',
    'local_bond_value': 'LOCTREBOND',
    'local_bond_net_ratio': 'LOCTREBONDRTO',
    'cb_bill_value': 'CBBILLMKTCAP',
    'cb_bill_net_ratio': 'CBBILLRTO',
    'fin_bond_value': 'FINBDMKTCAP',
    'fin_bond_net_ratio': 'FINBDRTO',
    'pol_fin_bond_value': 'POLFINBDMKTCAP',
    'pol_fin_bond_net_ratio': 'POLFINBDRTO',
    'corp_bond_value': 'CORPBDMKTCAP',
    'corp_bond_net_ratio': 'CORPBDRTO',
    'short_fin_bond_value': 'STFINBDMKTCAP',
    'short_fin_bond_net_ratio': 'STFINBDRTO',
    'med_bill_value': 'MTNOTEMKTCAP',
    'med_bill_net_ratio': 'MTNOTERTO',
    'conv_bond_value': 'CONVBDMKTCAP',
    'conv_bond_net_ratio': 'CONVBDRTO',
    'priv_bond_value': 'PRIVBDMKTCAP',
    'priv_bond_net_ratio': 'PRIVBDRTO',
    'ncd_value': 'NCD',
    'ncd_net_ratio': 'NCDRTO',
    'other_bond_value': 'OTHBDMKTCAP',
    'other_bond_net_ratio': 'OTHBDRTO',
    'abs_inv_value': 'ABSMKTCAP',
    'abs_net_ratio': 'ABSRTO',
    'fund_inv_value': 'FDMKTCAP',
    'fund_net_ratio': 'FDRTO',
    'deri_inv_value': 'DERIMKTCAP',
    'deri_net_ratio': 'DERIRTO',
    'for_inv_value': 'FORWMKTCAP',
    'for_net_ratio': 'FORWRTO',
    'fut_inv_value': 'FUTMKTCAP',
    'fut_net_ratio': 'FUTRTO',
    'opt_inv_value': 'OPNMKTCAP',
    'opt_net_ratio': 'OPNRTO',
    'war_inv_value': 'WRTMKTCAP',
    'war_net_ratio': 'WRTRTO',
    'buy_back_asset_value': 'BUYBFINASSMKTCAP',
    'buy_back_asset_net_ratio': 'BUYBFINASSRTO',
    'outright_repo_asset_value': 'OUTRTREPOMKTCAP',
    'outright_repo_net_ratio': 'OUTRIGHTREPORTO',
    'comm_spot_value': 'COMMSPOTMKTCAP',
    'comm_spot_net_ratio': 'COMMSPOTRTO',
    'gold_value': 'GOLDMKTCAP',
    'gold_net_ratio': 'GOLDRTO',
    'met_inv_value': 'PRECMETALCAP',
    'met_net_ratio': 'PRECMETALRTO',
    'cur_inv_value': 'CURFDSMKTCAP',
    'cur_net_ratio': 'CURFDSRTO',
    'deposit_inv_value': 'DEPOSITMKTCAP',
    'deposit_net_ratio': 'DEPOSITRTO',
    'bank_deposit': 'BKDEPOSITMKTCAP',
    'bank_deposit_net_ratio': 'BKDEPOSITRTO',
    'settlement_provisions': 'LIQUPROVMKTCAP',
    'settlement_provisions_net_ratio': 'LIQUPROVRTO',
    'other_asset_value': 'OTHINVEMKTCAP',
    'other_asset_net_ratio': 'OTHINVERTO',
    'refundable_deposits_value': 'MARGINMKTCAP',
    'refundable_deposits_net_ratio': 'MARGINRTO',
    'rec_sec_account': 'SECUCLINGMKTCAP',
    'rec_sec_account_net_ratio': 'SECUCLINGRTO',
    'rec_dividend': 'DVRECMKTCAP',
    'rec_dividend_net_ratio': 'DVRECRTO',
    'rec_interest': 'INTERECMKTCAP',
    'rec_interest_net_ratio': 'INTERECRTO',
    'rec_app_account': 'RECSACCAMKTCAP',
    'rec_app_account_net_ratio': 'RECSACCARTO',
    'other_rec_account': 'OTHRECEMKTCAP',
    'other_rec_account_net_ratio': 'OTHRECERTO',
    'prepaid_expenses': 'PREPEXPEMKTCAP',
    'prepaid_expenses_net_ratio': 'PREPEXPERTO',
    'other_value': 'OTHMKTCAP',
    'other_value_net_ratio': 'OTHRTO',
    'sell_rep_sec_account': 'SLREPASSEMKTCAP',
    'sell_rep_sec_net_ratio': 'SLREPASSERTO',
    'credit_balance': 'CREDITBALMKTCAP',
    'credit_balance_net_ratio': 'CREDITBALRTO',
}

FundInvestIndustryMap = {
    'sec_uni_code': 'SECURITYID',
    'announcement_date': 'PUBLISHDATE',
    'end_date': 'ENDDATE',
    'indu_standard': 'INDUSTRYTYPE',
    'indu_published_code': 'INDUSTRYCODE',
    'indu_published_name': 'INDUSTRYNAME',
    'indu_value': 'MKTCAP',
    'indu_value_net_ratio': 'ACCNETMKTCAP',
    'active_inv_value': 'M_ACTINVEST',
    'active_inv_net_ratio': 'A_ACTINVEST',
    'index_inv_value': 'M_INDEXINVEST',
    'index_inv_net_ratio': 'A_INDEXINVEST',
}

FundComHolderMap = {
    'org_uni_code': 'COMPCODE',
    'announcement_date': 'PUBLISHDATE',
    'begin_date': 'BEGINDATE',
    'end_date': 'ENDDATE',
    'shareholder_name': 'SHHOLDNAME',
    'hold_shr_vol': 'HOLDQUT',
    'hold_shr_prop': 'HOLDRTO',
    'serial_number': 'HOLDERRANK',
    'source_id': 'SHHOLDCODE'
}

FundCodeMap = {
    'sec_uni_code': 'SECURITYID',
    'map_type': 'MAPTYPE',
    'map_code': 'MAPCODE',
    'abc_code': 'ABC_CODE',
    'map_name': 'MAPNAME',
    'begin_date': 'BEGINDATE',
    'end_date': 'ENDDATE',
    'is_valid': 'ISVALID',
}

FundCodeFromSecBasicMap = {
    'sec_uni_code': 'sec_uni_code',
    'map_type': 'map_type',
    'map_code': 'sec_code',
    'abc_code': 'abc_code',
    'begin_date': 'ipo_date',
    'end_date': 'end_date',
}

BondsSecuritiesMap = {
    'com_uni_code': 'COMPCODE',
    'sec_name': 'SESNAME',
    'sec_fname': 'SENAME',
    'sec_code': 'SYMBOL',
    'abc_code': 'SECODE',
    'sec_type': 'SEC_TYPE',
    'sec_small_type': 'SETYPE',
    'sec_short_name': 'SESPELL',
    'ipo_status': 'LISTSTATUS',
    'security_type': 'EXCHANGE',
    'ipo_date': 'LISTDATE',
    'end_date': 'DELISTDATE',
    'currency_type': 'CUR',
    'come_source': 'COME_SOURCE',
    'source_id': 'SOURCE_ID',
}

FundHshkIndustryMap = {
    'sec_uni_code': 'SECURITYID',
    'announcement_date': 'DECLAREDATE',
    'end_date': 'REPORTDATE',
    'indu_standard': 'INDCLASSCODE',
    'indu_published_code': 'INDUSTRYCODE',
    'indu_published_name': 'INDUSTRYNAME',
    'indu_value': 'indu_value',
    'indu_value_net_ratio': 'indu_value_net_ratio',
    'active_inv_value': 'active_inv_value',
    'active_inv_net_ratio': 'active_inv_net_ratio',
    'index_inv_value': 'index_inv_value',
    'index_inv_net_ratio': 'index_inv_net_ratio',
}

FundInvestStockMap = {
    'sec_uni_code': 'SECURITYID',
    'announcement_date': 'PUBLISHDATE',
    'end_date': 'ENDDATE',
    'inv_sec_uni_code': 'SYMBOL',
    'inv_sec_code': 'SYMBOL',
    'inv_sec_name': 'SKNAME',
    'inv_sec_type': 'inv_sec_type',
    'hold_sec_amount': 'hold_sec_amount',
    'hold_sec_value': 'hold_sec_value',
    'sec_value_net_ratio': 'sec_value_net_ratio',
    'active_inv_amount': 'active_inv_amount',
    'active_inv_value': 'active_inv_value',
    'active_inv_net_ratio': 'active_inv_net_ratio',
    'index_inv_amount': 'index_inv_amount',
    'index_inv_value': 'index_inv_value',
    'index_inv_net_ratio': 'index_inv_net_ratio',
}

FundInvestBondsMap = {
    'sec_uni_code': 'SECURITYID',
    'announcement_date': 'PUBLISHDATE',
    'end_date': 'ENDDATE',
    'inv_sec_uni_code': 'BONDCODE',
    'inv_sec_code': 'BONDCODE',
    'inv_sec_name': 'BONDNAME',
    'inv_sec_type': 'BONDCODE',
    'hold_sec_amount': 'HOLDAMT',
    'hold_sec_value': 'HOLDMKTCAP',
    'sec_value_net_ratio': 'NAVRTO',
}

FundInvestFundMap = {
    'sec_uni_code': 'SECURITYID',
    'announcement_date': 'PUBLISHDATE',
    'end_date': 'ENDDATE',
    'inv_sec_uni_code': 'FUNDCODE',
    'inv_sec_code': 'FUNDCODE',
    'inv_sec_name': 'FUNDNAME',
    'inv_sec_type': 'FUNDCODE',
    'hold_sec_amount': 'HOLDAMT',
    'hold_sec_value': 'HOLDMKTCAP',
    'sec_value_net_ratio': 'NAVRTO',
}

IntermediaryOrgMap = {
    'sec_uni_code': 'SECURITYID',
    'announcement_date': 'PUBLISHDATE',
    'begin_date': 'BEGINDATE',
    'end_date': 'ENDDATE',
    'org_type': 'PARTYTYPE',
    'org_name': 'COMPNAME',
    'org_uni_code': 'COMPCODE',
    'is_valid': 'ISVALID',
}

FundPortfolioChangeMap = {
    'sec_uni_code': 'SECURITYID',
    'announcement_date': 'PUBLISHDATE',
    'end_date': 'REPORTDATE',
    'inv_sec_uni_code': 'SYMBOL',
    'inv_sec_code': 'SYMBOL',
    'inv_sec_name': 'SKNAME',
    'serial_number': 'RANK',
    'change_direction': 'CHGDIRECTION',
    'change_amount': 'CHGAMT',
    'initial_nav_ratio': 'ININAVRTO',
}

FundPortfolioChangeQDIIMap = {
    'sec_uni_code': 'SECURITYID',
    'announcement_date': 'DECLAREDATE',
    'end_date': 'REPORTDATE',
    'inv_sec_code': 'ESYMBOL',
    'inv_sec_name': 'COMPANYNAME',
    'serial_number': 'STOCKRANK',
    'change_direction': 'CHANGEPATH',
    'change_amount': 'CHANGEAMT',
    'initial_nav_ratio': 'NAVRATIO',
}

QDIIFundNationAllocationMap = {
    'sec_uni_code': 'SECURITYID',
    'announcement_date': 'DECLAREDATE',
    'end_date': 'REPORTDATE',
    'country_code': 'COUNTRYCODE',
    'country_name': 'COUNTRY',
    'indu_value': 'SKMARKETV',
    'indu_value_net_ratio': 'NAVRATIO',
}

QDIIFundInvestIndustryMap = {
    'sec_uni_code': 'SECURITYID',
    'announcement_date': 'DECLAREDATE',
    'end_date': 'REPORTDATE',
    'indu_standard': 'INDCLASS',
    'indu_published_code': 'INDUSTRYCODE',
    'indu_published_name': 'INDUSTRYNAME',
    'indu_value': 'MARKETV',
    'indu_value_net_ratio': 'PROPORTION',
}

QDIIFundRatedBondMap = {
    'sec_uni_code': 'SECURITYID',
    'announcement_date': 'DECLAREDATE',
    'end_date': 'ENDDATE',
    'credit_rating_code': 'CREDITRCODE',
    'credit_rating_name': 'CREDITRCN',
    'sec_value': 'FAIRVALUE',
    'sec_value_net_ratio': 'NAVRATIO',
}

QDIIFundInvestDetailMap = {
    'sec_uni_code': 'SECURITYID',
    'announcement_date': 'DECLAREDATE',
    'end_date': 'ENDDATE',
    'inv_sec_code': 'SYMBOL',
    'inv_sec_name': 'SNAME',
    'inv_sec_type': 'STYPE',
    'currency_type': 'CUR',
    'hold_sec_amount': 'HOLDVOL',
    'hold_sec_value': 'HOLDVALUE',
    'sec_value_net_ratio': 'ACCTFORNAV',
}

FundShareChangeMap = {
    'sec_uni_code': 'SECURITYID',
    'announcement_date': 'DECLAREDATE',
    'end_date': 'REPORTDATE',
    'report_type': 'REPORTTYPE',
    'share_chg_reason': 'CHGRSN',
    'ini_fund_share': 'INIFDSHARE',
    'tot_app_share': 'SUBSHARETOT',
    'tot_redem_share': 'REDTOTSHARE',
    'split_chg_share': 'SPLITADDSHARE',
    'final_fund_share': 'ENDFDSHARE',
    'uncirc_orig_share': 'NCIRCORIGSHARE',
    'circ_orig_share': 'CIRCORIGSHARE',
    'circ_tot_share': 'CIRCSHARE',
    'public_share': 'PUBLICSHARE',
    'inst_inv_share': 'INSTINVESHARE',
    'is_stat': 'ISSTAT',
    'is_valid': 'ISVALID',
    'remark': 'REMARK',
}

MMFRMaturityMap = {
    'sec_uni_code': 'SECURITYID',
    'announcement_date': 'DECLAREDATE',
    'end_date': 'PUBLISHDATE',
    'd30_asset_nav_ratio': 'D30ASSETNAVRTO',
    'd30_asset_fltb_over_397d': 'D30ASSETFLTG397D',
    'd30_liab_nav_ratio': 'D30LIABNAVRTO',
    'd30_liab_fltb_over_397d': 'D30LIABFLTG397D',
    'd30_60_asset_nav_ratio': 'D30T60DASSETNAVRTO',
    'd30_60_asset_fltb_over_397d': 'D30T60DASSETFLTG397D',
    'd30_60_liab_nav_ratio': 'D30T60DLIABNAVRTO',
    'd30_60_liab_fltb_over_397d': 'D30T60DLIABFLTG397D',
    'd60_90_asset_nav_ratio': 'D60T90DASSETNAVRTO',
    'd60_90_asset_fltb_over_397d': 'D60T90DASSETFLTG397D',
    'd60_90_liab_nav_ratio': 'D60T90DLIABNAVRTO',
    'd60_90_liab_fltb_over_397d': 'D60T90DLIABFLTG397D',
    'd90_120_asset_nav_ratio': 'D90T120DASSETNAVRTO',
    'd90_120_asset_fltb_over_397d': 'D90T120DASSETFLTG397D',
    'd90_120_liab_nav_ratio': 'D90T120DLIABNAVRTO',
    'd90_120_liab_fltb_over_397d': 'D90T120DLIABFLTG397D',
    'd90_180_asset_nav_ratio': 'D90T180DASSETNAVRTO',
    'd90_180_asset_fltb_over_397d': 'D90T180DASSETFLTG397D',
    'd90_180_liab_nav_ratio': 'D90T180DLIABNAVRTO',
    'd90_180_liab_fltb_over_397d': 'D90T180DLIABFLTG397D',
    'd120_397_asset_nav_ratio': 'D120ASSETNAVRTO',
    'd120_397_asset_fltb_over_397d': 'D120ASSETFLTG397D',
    'd120_397_liab_nav_ratio': 'D120LIABNAVRTO',
    'd120_397_liab_fltb_over_397d': 'D120LIABFLTG397D',
    'd180_397_asset_nav_ratio': 'D180ASSETNAVRTO',
    'd180_397_asset_fltb_over_397d': 'D180ASSETFLTG397D',
    'd180_397_liab_nav_ratio': 'D180LIABNAVRTO',
    'd180_397_liab_fltb_over_397d': 'D180LIABFLTG397D',
    'asset_nav_ratio_acc': 'ASSETACCNAV',
    'liab_nav_ratio_acc': 'LIABACCNAV'
}

FundHolderInfoMap = {
    'sec_uni_code': 'SECURITYID',
    'announcement_date': 'PUBLISHDATE',
    'end_date': 'ENDDATE',
    'holder_num': 'HOLDERNUM',
    'avg_hold_shares': 'AVGSHARE',
    'institution_hold_shares': 'INVSHARE',
    'institution_hold_ratio': 'INVTOTRTO',
    'individual_hold_shares': 'INDIVIDUALSHARE',
    'individual_hold_ratio': 'INDIVIDUALTOTRTO',
    'management_hold_shares': 'KEEPERSHARE',
    'management_hold_ratio': 'KEEPERTOTRTO',
    'management_shareholder_shares': 'SHHOLDERSHARE',
    'management_shareholder_ratio': 'SHHOLDERTOTRTO',
    'professional_hold_shares': 'STAFFSHARE',
    'professional_hold_ratio': 'STAFFTOTRTO',
    'undefined_hold_shares': 'UNCONFSHARE',
    'undefined_hold_ratio': 'UNCONFTOTRTO',
    'is_stat': 'ISSTAT',
    'remark': 'MEMO',
}

FundTopTenHolderMap = {
    'sec_uni_code': 'SECURITYID',
    'announcement_date': 'PUBLISHDATE',
    'end_date': 'ENDDATE',
    'holder_serial_number': 'HOLDERRANK',
    'holder_type': 'HOLDERTYPE',
    'holder_name': 'HOLDERNAME',
    'holder_code': 'HOLDERCODE',
    'eop_shares': 'HOLDSHARE',
    'eop_shares_ratio': 'HOLDRTO',
}

FundTradingShareMap = {
    'sec_uni_code': 'SECURITYID',
    'announcement_date': 'PUBLISHDATE',
    'trade_date': 'TRADEDATE',
    'current_share': 'CURSHARE',
}

MMFIndexBrepoMap = {
    'sec_uni_code': 'SECURITYID',
    'begin_date': 'BEGINDATE',
    'end_date': 'ENDDATE',
    'report_type': 'REPORTTYPE',
    'eop_bond_repo_balance': 'REPEDBDREPOBALA',
    'eop_outright_bond_repo_balance': 'BBACKFINANCING',
    'drp_bond_repo_balance_net_ratio': 'REPINBDREBPROFD',
    'drp_outright_bond_repo_balance_net_ratio': 'REPINOUTREPROFD',
    'eop_bond_repo_balance_net_ratio': 'REPEDBDREPROFD',
    'eop_outright_bond_repo_balance_net_ratio': 'REPEDOUTREPROFD',
}

MMFIndexAssdevMap = {
    'sec_uni_code': 'SECURITYID',
    'begin_date': 'BEGINDATE',
    'end_date': 'ENDDATE',
    'report_type': 'REPORTTYPE',
    'drp_abs_deviation': 'AVGREPORDEVIONM',
    'drp_max_deviation': 'HIGHREPORDEVION',
    'drp_min_deviation': 'LOWREPORDEVION',
    'drp_avg_daily_deviation': 'AVGREPORDEVION',
}

MMFIndexCurAvgMMONFMap = {
    'sec_uni_code': 'SECURITYID',
    'end_date': 'PUBLISHDATE',
    'eop_avg_remaining_maturity': 'AVGRESMAT',
    'eop_max_avg_remaining_maturity': 'AVGMAXRESMAT',
    'eop_min_avg_remaining_maturity': 'AVGMINRESMAT',
}

FundStockTradingMap = {
    'sec_uni_code': 'SECURITYID',
    'announcement_date': 'DECLAREDATE',
    'begin_date': 'BEGINDATE',
    'end_date': 'ENDDATE',
    'buy_stock_tot_cost': 'BUYSKTOTCOST',
    'sale_stock_tot_income': 'SALESKTOTCOST',
    'beg_fund_nav': 'TOTFDNAVBEG',
    'end_fund_nav': 'TOTFDNAVEND',
    'beg_stock_value': 'SKMKTCAPBEG',
    'end_stock_value': 'SKMKTCAPEND',
    'asset_activity': 'ASSETSACTIVE',
    'fund_stock_turnover_rate': 'TURNOVERRATIO',
    'is_stat': 'ISSTAT',
}

FundTCSsionMap = {
    'sec_uni_code': 'SECURITYID',
    'announcement_date': 'PUBLISHDATE',
    'begin_date': 'TRADEBEGDATE',
    'end_date': 'TRADEENDDATE',
    'broker_name': 'BROKERNAME',
    'broker_code': 'BROKERID',
    'rent_seats': 'LENTSEATQUT',
    'commission': 'COMM',
    'tot_commission_ratio': 'ACCTOTCOMM',
    'stock_trading_amount': 'STKTRADEQUT',
    'tot_stock_trading_amount_ratio': 'ACCSTKTRADEQUT',
    'bond_trading_amount': 'BONDTRADINGAMOUNT',
    'tot_bond_trading_amount_ratio': 'TOTBONDTRADINGAMOUNTRATIO',
    'bondrepo_trading_amount': 'REPUTRADEQUT',
    'tot_bondrepo_trading_amount_ratio': 'ACCREPUTRADEQUT',
    'warrant_trading_amount': 'WRTVOL',
    'tot_warrant_trading_amount_ratio': 'ACCWRTTRADEQUT',
    'fund_trading_amount': 'SECURITYVOL',
    'tot_fund_trading_amount_ratio': 'ACCSECURITYTRADEQUT',
    'is_stat': 'ISSTAT',
    'remark': 'MEMO',
}

FMFIndexMap = {
    'sec_uni_code': 'SECURITYID',
    'announcement_date': 'PUBLISHDATE',
    'begin_date': 'BEGINDATE',
    'end_date': 'ENDDATE',
    'report_type': 'REPORTTYPE',
    'accounting_standard_code': 'ACCSTACODE',
    'accounting_standard_name': 'ACCSTANAME',
    'currency_type': 'CUR',
    'period_profit': 'PROFITPERIOD',
    'net_income': 'FDNETPROPER',
    'avg_pershare_period_profit': 'AVGFDPROPER',
    'pershare_net_income': 'UNFDNETINCPER',
    'fund_available_net_income': 'FDDISTNETINC',
    'pershare_available_net_income': 'UNFDDISTNETINC',
    'eop_tot_asset': 'FINAFDTOTASSET',
    'eop_tot_nav': 'FINAFDASSETNAV',
    'eop_unit_nav': 'FINAUNFDASSNAV',
    'tot_nav_return': 'FDASSETNAVYIELD',
    'dist_return': 'FDDISTYIELD',
    'wgt_avg_nav_return': 'FDAVGNAVYIELD',
    'unit_nav_return': 'FDNAVGROWRATE',
    'cumu_unit_nav_return': 'FDACCGROWATE',
    'is_stat': 'ISSTAT',
}

FundBalanceSheetMap = {
    'sec_uni_code': 'SECURITYID',
    'announcement_date': 'PUBLISHDATE',
    'end_date': 'REPORTDATE',
    'report_type': 'REPORT_TYPE',
    'accounting_standard_code': 'ACCSTACODE',
    'accounting_standard_name': 'ACCSTANAME',
    'currency_type': 'CUR',
    'cash': 'CASH',
    'bank_deposit': 'DEPOINBANK',
    'settlement_provisions': 'LIQUPROV',
    'refundable_deposits': 'TRADMARG',
    'stk_inv_value': 'STKINVEMKTCAP',
    'stk_inv_cost': 'STKINVECOST',
    'stk_inv_val_add': 'STKIVALA',
    'bond_inv_value': 'BDINVEMKTCAP',
    'bond_inv_cost': 'BDINVECOST',
    'bond_inv_val_add': 'BDINVEVALAPP',
    'conv_bond_cost': 'CONVBDCOST',
    'conv_bond_val_add': 'CONVBDVALAPP',
    'war_inv_value': 'WRTINVE',
    'war_inv_cost': 'WRTCOST',
    'natl_bond_value': 'NATDINVEMKTC',
    'natl_bond_cost': 'NATDINVECOST',
    'natl_bond_val_add': 'NATDVALAPP',
    'buy_back_fin_asset_cost': 'BUYREVBDCOST',
    'other_inv_cost': 'OTHERINVECOST',
    'other_inv_val_add': 'OTHERINVEVALAPP',
    'rec_sec_account': 'RECESTKL',
    'rec_interest': 'TOTINTE',
    'rec_dividend': 'DIVIDRECE',
    'rec_dividend_bank_int': 'DIVIBKIN',
    'rec_app_account': 'NEWSSUBP',
    'rec_account': 'ACCORECE',
    'allot_war': 'ALLOWRT',
    'prepaid_expenses': 'PREPEXPE',
    'other_asset': 'OTHERRECEACCT',
    'total_asset': 'FDTOTASSET',
    'pay_sec_account': 'PAYBLIQU',
    'pay_redem_account': 'PAYACC',
    'pay_redem_fee': 'PAYREDF',
    'pay_management_fee': 'PAYFDMANF',
    'meritpay': 'MERITPAY',
    'pay_trust_fee': 'PAYFDTRUS',
    'pay_sales_serv_fee': 'PAYSSERV',
    'pay_seat_use_fee': 'PAYSUSEF',
    'pay_trading_fee': 'COMMPAYA',
    'pay_interest': 'INTEPAYA',
    'pay_profit': 'PAYINCO',
    'pay_allot_account': 'PAYALLO',
    'sell_repo_fin_asset': 'SELLBACKBDINCO',
    'pay_account': 'PAYTOTA',
    'pay_tax': 'UNPATAXES',
    'accrued_expenses': 'ACCREXPE',
    'other_liab': 'OTHERPAY',
    'total_liab': 'TOTALLIAB',
    'paid_fund': 'FDTOTUNIT',
    'net_income': 'NETINCO',
    'unrea__val_add': 'UNREAVALA',
    'nopay_profit': 'UNALNETI',
    'total_account_equity': 'ASSETNAV',
    'total_account_equity_and_liab': 'LIABTOTH',
    'is_stat': 'ISSTAT',
}

FundBalanceSheetNewMap = {
    'sec_uni_code': 'SECURITYID',
    'announcement_date': 'PUBLISHDATE',
    'end_date': 'REPORTDATE',
    'report_type': 'REPORTTYPE',
    'accounting_standard_code': 'ACCSTACODE',
    'accounting_standard_name': 'ACCSTANAME',
    'currency_type': 'CUR',
    'bank_deposit': 'DEPOINBANK',
    'settlement_provisions': 'SETTRESEDEPO',
    'refundable_deposits': 'KEPTMARG',
    'trading_fin_asset': 'TRADFINASSET',
    'stk_inv_value': 'STKINVE',
    'fund_inv_value': 'FDINVE',
    'bond_inv_value': 'BDINVE',
    'abs_inv_value': 'ASSESECI',
    'deri_fin_asset': 'DERIFINAASSET',
    'buy_back_fin_asset': 'PURCRESAASSET',
    'rec_sec_account': 'RECESECU',
    'rec_interest': 'INTERECE',
    'rec_dividend': 'DIVIDRECE',
    'rec_app_account': 'RECSACCA',
    'other_asset': 'OTHERASSE',
    'total_asset': 'TOTASSET',
    'short_term_loan': 'SHORTTERMBORR',
    'trading_fin_liab': 'TRADFINLIAB',
    'deri_fin_liab': 'DERILIAB',
    'sell_repo_fin_asset': 'SELLREPASSE',
    'pay_sec_account': 'PAYSLIQU',
    'pay_redem_account': 'PAYACC',
    'pay_management_fee': 'PAYFDMANF',
    'pay_trust_fee': 'PAYFDTRUS',
    'pay_sales_serv_fee': 'PAYSSERV',
    'pay_trading_fee': 'PAYTFEE',
    'pay_tax': 'TAXESPAYA',
    'pay_interest': 'INTEPAYA',
    'pay_profit': 'PROFPAYA',
    'other_liab': 'OTHERLIABI',
    'total_liab': 'TOTLIAB',
    'paid_fund': 'PAIDFD',
    'nopay_profit': 'UNDIPROF',
    'total_account_equity': 'TOTALOWNEREQUI',
    'total_account_equity_and_liab': 'TOTALLIABSHAREQUI',
    'is_stat': 'ISSTAT',
    'remark': 'MEMO',
}

FundIncomeStatementMap = {
    'sec_uni_code': 'SECURITYID',
    'announcement_date': 'PUBLISHDATE',
    'begin_date': 'BEGINDATE',
    'end_date': 'ENDDATE',
    'report_type': 'REPORTTYPE',
    'accounting_standard_code': 'ACCSTACODE',
    'accounting_standard_name': 'ACCSTANAME',
    'currency_type': 'CUR',
    'total_income': 'TOTINC',
    'sec_spread_income': 'SECUSPRI',
    'stk_spread_income': 'STKTRAS',
    'bond_spread_income': 'BDTRAS',
    'conv_bond_income': 'CONVBDINCO',
    'wrt_spread_income': 'ALLOWRTI',
    'other_spread_income': 'OTHERSPRI',
    'tot_inv_income': 'INVETOTI',
    'stk_inv_income': 'STKINVE',
    'bond_inv_income': 'BDINVEINCO',
    'conv_inv_income': 'CONVBDPRO',
    'other_inv_income': 'OTHERINVEINCO',
    'repo_income': 'REPINCO',
    'total_other_income': 'OTHERINCOTOT',
    'deposit_interest_income': 'BKDEINTE',
    'iss_fee_income': 'ISSFEEBALA',
    'app_interest_income': 'PURCINTE',
    'fee_return': 'FEERETU',
    'other_income': 'OTHER',
    'total_fee': 'TOTALFEE',
    'management_fee': 'FDMANAINCO',
    'meritpay': 'MERITPAY',
    'trust_fee': 'FDCUSTFEE',
    'repo_trading_fee': 'REPTRAFEE',
    'repo_interest_expense': 'REPINTEFEE',
    'sales_serv_fee': 'SELLSERF',
    'list_fee': 'LISTANNFEE',
    'list_reco_fee': 'LISTREFFEE',
    'iss_expo_fee': 'ISSCOORFEE',
    'acco_fee': 'ACCOFEE',
    'law_fee': 'LAWYFEE',
    'bank_fee': 'BANKFEE',
    'holder_meeting_fee': 'HMFEE',
    'info_fee': 'INFOPUBFEE',
    'broker_fee': 'BROKFEE',
    'exchange_bonus_fee': 'EXCHBONUSFEE',
    'iss_fee_balance': 'ISSBALA',
    'expo_fee_balance': 'EXPOBALA',
    'bond_acc_main_fee': 'BDACCMAIFEE',
    'other_expense': 'OTHERPAY',
    'exchange_repo_trading_fee': 'EXCHTRADEFEE',
    'other_fee': 'OTHERFEE',
    'fund_net_income': 'FDNETI',
    'avg_pershare_fund_net_income': 'AVGFDNETINC',
    'unrea_val_add': 'UNREVALA',
    'fund_opera_return': 'FDRESO',
    'bop_nopay_net_income': 'FINANETIN',
    'app_profit_loss_amount': 'SUBFDLOSE',
    'redem_profit_loss_amount': 'REDFDLOSE',
    'profit_loss_amount': 'PROLEQUP',
    'dist_fund_net_income': 'CDISNETINCR',
    'allo_fund_net_income': 'ADISNETI',
    'prev_income_adj': 'PROFLOSSADJU',
    'eop_nopay_net_income': 'FINANETI',
    'is_stat': 'ISSTAT',
}

FundIncomeStatementNewMap = {
    'sec_uni_code': 'SECURITYID',
    'announcement_date': 'PUBLISHDATE',
    'begin_date': 'BEGINDATE',
    'end_date': 'ENDDATE',
    'report_type': 'REPORTTYPE',
    'accounting_standard_code': 'ACCSTACODE',
    'accounting_standard_name': 'ACCSTANAME',
    'currency_type': 'CUR',
    'income': 'INC',
    'interest_income': 'TOTINTEINCO',
    'deposit_interest_income': 'DEPOINTEINC',
    'bond_interest_income': 'BDINTEINCO',
    'abs_interest_income': 'ASSBINTE',
    'buy_back_fin_asset_income': 'BUYFIN',
    'investment_income': 'INVETOTR',
    'stk_inv_income': 'STKINVE',
    'fund_inv_income': 'FDINVEQD',
    'bond_inv_income': 'BDINVEINCO',
    'abs_inv_income': 'ASSBINVI',
    'deri_inv_income': 'DERIINVE',
    'stk_dividend': 'DIVIINVE',
    'fair_val_chg_income': 'VALUECHGLOSS',
    'exchange_income': 'EXCHGGAIN',
    'other_income': 'OTHERINCO',
    'fee': 'FEE',
    'management_fee': 'MANAFEE',
    'cust_main_fee': 'CUSTMAINFEE',
    'trust_fee': 'CUSTFEE',
    'sales_serv_fee': 'SELLSERF',
    'trading_fee': 'TRADEFEE',
    'interest_expense': 'INTEEXPE',
    'sell_repo_expense': 'SELLFIN',
    'financial_fee': 'FINEXPE',
    'other_fee': 'OTHERFEE',
    'audit_fee': 'AUDITFEE',
    'info_fee': 'INFOPUBFEE',
    'bank_charge': 'BANKCHAR',
    'account_fee': 'ACCTMAIN',
    'seat_fee': 'SEATUSEF',
    'list_fee': 'LISTANNFEE',
    'other': 'OTHER',
    'total_profit': 'TOTPROFIT',
    'income_tax_fee': 'INCOTAXEXPE',
    'net_profit': 'NETPROFIT',
    'is_stat': 'ISSTAT',
    'remark': 'MEMO',
}

FundNavChangeMap = {
    'sec_uni_code': 'SECURITYID',
    'announcement_date': 'PUBLISHDATE',
    'begin_date': 'BEGINDATE',
    'end_date': 'ENDDATE',
    'report_type': 'REPORTTYPE',
    'accounting_standard_code': 'ACCSTACODE',
    'accounting_standard_name': 'ACCSTANAME',
    'currency_type': 'CUR',
    'bop_tot_nav': 'INIFDNAV',
    'fund_net_income': 'FDNETINC',
    'unrea_profit': 'UNREPROF',
    'opera_tot_nav_chg': 'OPERFDNA',
    'prev_income_adj': 'PROFLOSSADJU',
    'fund_app_account': 'FDSUBINCO',
    'fund_redem_account': 'FDREDEACCT',
    'fund_expo_account': 'FDEXPOFEE',
    'fund_trading_unit_nav_chg': 'FDTRADENAVCHG',
    'holder_profit_dist_nav_chg': 'HOLDINCRNAVCHG',
    'eop_tot_nav': 'FINANAV',
    'is_stat': 'ISSTAT',
}

FundNavChangeNewMap = {
    'sec_uni_code': 'SECURITYID',
    'announcement_date': 'PUBLISHDATE',
    'adjust_date': 'ADJUSTDATE',
    'begin_date': 'BEGINDATE',
    'end_date': 'ENDDATE',
    'report_type': 'REPORTTYPE',
    'accounting_standard_code': 'ACCSTACODE',
    'accounting_standard_name': 'ACCSTANAME',
    'currency_type': 'CUR',
    'project_code': 'PROJECTCODE',
    'project_name': 'PROJNAME',
    'paid_fund': 'PAIDFD',
    'nopay_profit': 'UNDIPROF',
    'total_account_equity': 'OWNERTOTE',
    'is_stat': 'ISSTAT',
}

FundProfitDistMap = {
    'sec_uni_code': 'SECURITYID',
    'announcement_date': 'DECLAREDATE',
    'begin_date': 'BEGINDATE',
    'end_date': 'ENDDATE',
    'ten_dividends': 'DIVIDENDS',
    'cash_payment_amount': 'CASHPAYMENT',
    'reinve_amount': 'REINVESTMENT',
    'annual_profit_distribution': 'ADISTRIBUTION',
    'reinve_paid_fund': 'REINVFUNDS',
    'pay_redem_trans_amount': 'TRANSAMOUNT',
    'pay_profit_chg': 'PROFITCHANGES',
    'is_stat': 'ISSTAT',
}

FundUndistProfitNewMap = {
    'sec_uni_code': 'SECURITYID',
    'announcement_date': 'PUBLISHDATE',
    'adjust_date': 'ADJUSTDATE',
    'begin_date': 'BEGINDATE',
    'end_date': 'ENDDATE',
    'report_type': 'REPORTTYPE',
    'accounting_standard_code': 'ACCSTACODE',
    'accounting_standard_name': 'ACCSTANAME',
    'currency_type': 'CUR',
    'project_code': 'PROJECTCODE',
    'project_name': 'PROJNAME',
    'achieve_portion': 'ACHIPORTION',
    'unreal_portion': 'UNREALPORTION',
    'tot_undist_profit': 'TOTUNALLOPROFIT',
    'is_stat': 'ISSTAT',
}

FundFinancialNoteMap = {
    'sec_uni_code': 'SECURITYID',
    'announcement_date': 'DECLAREDATE',
    'begin_date': 'BEGINDATE',
    'end_date': 'ENDDATE',
    'report_type': 'REPORTTYPE',
    'currency_type': 'CUR',
    'unit': 'UNIT',
    'subject_type': 'SUBJECTTYPE',
    'subject_code': 'SUBJECTCODE',
    'subject_name': 'SUBJECTNAME',
    'announce_subject_name': 'SUBNAMEDECL',
    'amount': 'AMOUNT',
    'is_stat': 'ISSTAT',
    'remark': 'MEMO',
}

FundSplitConversionMap = {
    'sec_uni_code': 'SECURITYID',
    'announcement_date': 'PUBLISHDATE',
    'split_conversion_type': 'DIVITYPE',
    'split_conversion_status': 'DIVIIMPMARKD',
    'share_change_record_date': 'RECORDCHGDATE',
    'split_conversion_date': 'SPLITDATE',
    'estimate_split_conversion_ratio': 'ESPLITRATIO',
    'split_conversion_ratio': 'SPLITRATIO',
    'begin_split_conversion_share': 'BESPLITSH',
    'after_split_conversion_share': 'AFSPLITSH',
    'begin_split_conversion_unit_nav': 'BESPLITNAV',
    'after_split_conversion_unit_nav': 'AFSPLITNAV',
    'begin_split_conversion_cumu_nav': 'BESPLITACCNAV',
    'after_split_conversion_cumu_nav': 'AFSPLITACCNAV',
    'dividend_base_date': 'DISBENCHDATE',
    'is_dividend': 'ISBONUS',
    'currency_type': 'CUR',
    'split_year': 'SPLITSYEAR',
    'annual_cumu_split_amount': 'CURYACCSLSAMT',
    'remark': 'MEMO',
}

StructFundBasicMap = {
    'sec_uni_code': 'SECURITYID',
    'fund_sname': 'SESNAME',
    'fund_main_code': 'SECURITYIDCOMP',
    'share_type': 'SHARETYPE',
    'is_pair_conversion': 'ISCONVERTED',
    'initial_leverage_max': 'LEVERAGEMAX',
    'share_matching_ratio': 'MACTHRATIO',
    'closed_period': 'CLOSPERIOD',
    'closed_period_unit': 'CLOSPERIODUNIT',
    'after_closed_period_type': 'AFCLSTYPE',
    'after_operate_period_type': 'AFOPRTYPE',
    'is_convert_lof': 'ISLOF',
    'is_regular_convert': 'ISREGULARCVT',
    'regular_convert_base_date': 'CONVERTBASEDATE',
    'regular_convert_type': 'CONVERTTYPE',
    'regular_convert_cycle': 'REGCVTCYCLE',
    'regular_convert_cycle_unit': 'REGCVTCUNIT',
    'irregular_convert_clause': 'NOCONVERT',
    'is_up_irregular_convert': 'ISUPCONVERT',
    'up_irregular_convert_clause': 'UPCONVERTTYPE',
    'is_down_irregular_convert': 'ISDWCONVERT',
    'down_irregular_convert_clause': 'DWCONVERTTYPE',
    'is_stable_matching_ratio': 'ISSTABLE',
    'is_parent_real_app_redem': 'ISMASTERRED',
}

StructFundPreReturnMap = {
    'sec_uni_code': 'SECURITYID',
    'announcement_date': 'DECLAREDATE',
    'begin_date': 'BEGINDATE',
    'end_date': 'ENDDATE',
    'calc_type': 'ITYPE',
    'interest_type': 'CALTYPE',
    'change_frequency': 'CHANGEFREP',
    'predicted_annual_return_memo': 'ELDMEMO',
    'is_taxed': 'ISTAXED',
    'benchmark_interest_rate_name': 'BMKNAME',
    'benchmark_interest_rate': 'BENCHMARK',
    'multiple': 'MULTIPLE',
    'interest_margin': 'IMARGIN',
    'remark': 'MEMO',
}

StructFundShareMatchMap = {
    'sec_uni_code': 'SECURITYID',
    'announcement_date': 'UPDATEDATE',
    'begin_date': 'BEGINDATE',
    'end_date': 'ENDDATE',
    'priority_sec_uni_code': 'SECURITYIDA',
    'general_sec_uni_code': 'SECURITYIDB',
    'parent_fund_share_matching': 'MASTERRATIO',
    'priority_fund_share_matching': 'AFUNDRATION',
    'general_fund_share_matching': 'BFUNDRATIO',
}

StructFundThresholdMap = {
    'sec_uni_code': 'SECURITYID',
    'announcement_date': 'UPDATEDATE',
    'begin_date': 'BEGINDATE',
    'end_date': 'ENDDATE',
    'currency_type': 'CUR',
    'relationship_type': 'RELATIONTYPE',
    'conditional_relationship': 'RELATIONCOND',
    'threshold': 'THRESHOLD',
    'is_convert': 'ISCONVERTED',
    'multiple_fund_uni_code': 'MULSECURITYID',
    'remark': 'MEMO',
}

FundSRStatusMap = {
    'sec_uni_code': 'SECURITYID',
    'sub_redem_status': 'STATUS',
    'status_begin_date': 'SUBREDBEGDATE',
    'status_end_date': 'SUBREDENDDATE',
}

FundPrizeMap = {
    'announcement_date': 'DECLAREDATE',
    'update_date': 'UPDATEDATE',
    'prize_year': 'PRIZEYEAR',
    'prize_object_type': 'OBJPRIZE',
    'prize_object_code': 'OBJCODE',
    'prize_object_name': 'OBJNAME',
    'sponsor_code': 'SPONSORCODE',
    'sponsor_name': 'SPONSORNAME',
    'prize_code': 'PRIZECODE',
    'prize_name': 'PRIZENAME',
}

FundISplitConversionMap = {
    'sec_uni_code': 'SECURITYID',
    'sec_code': 'SYMBOL',
    'announcement_date': 'DECLAREDATE',
    'update_date': 'UPDATEDATE',
    'split_conversion_date': 'CONVERTDATE',
    'split_conversion_type': 'CONVERTCLASS',
    'new_split_conversion_ratio': 'NEWCONVERT',
    'begin_split_conversion_share': 'BCVTS',
    'begin_split_conversion_share_otc': 'BCVTSOTC',
    'begin_split_conversion_share_exc': 'BCVTSEXC',
    'after_split_conversion_share': 'ACVTS',
    'after_split_conversion_share_otc': 'ACVTSOTC',
    'after_split_conversion_share_exc': 'ACVTSEXC',
    'begin_split_conversion_unit_nav': 'BNAV',
    'begin_split_conversion_cumu_nav': 'BNAVCUML',
    'after_split_conversion_unit_nav': 'ANAV',
    'after_split_conversion_cumu_nav': 'ANAVCUML',
    'unit_nav_exceed': 'VALEXCEED',
    'send_sec_uni_code': 'FSCODE',
    'send_sec_code': 'FSSYMBOL',
    'send_new_split_conversion_ratio': 'SENDNEWR',
    'send_new_split_conversion_ratio_otc': 'SENDNEWROTC',
    'send_new_split_conversion_ratio_exc': 'SENDNEWREXC',
    'begin_send_share': 'BSENDS',
    'begin_send_share_otc': 'BSENDSOTC',
    'begin_send_share_exc': 'BSENDSEXC',
    'after_send_share': 'ASENDS',
    'after_send_share_otc': 'ASENDSOTC',
    'after_send_share_exc': 'ASENDSEXC',
    'gift_share': 'GIFTS',
    'gift_share_otc': 'GIFTSOTC',
    'gift_share_exc': 'GIFTSEXC',
    'begin_send_unit_nav': 'BSENDNAV',
    'begin_send_cumu_nav': 'BSENDNAVCUML',
    'after_send_unit_nav': 'ASENDNAV',
    'after_send_cumu_nav': 'ASENDNAVCUML',
    'add_share_ratio': 'SHARESCALE',
    'remark': 'MEMO',
}

FundMangerInfoMap = {
    'org_uni_code': 'COMPCODE',
    'announcement_date': 'DECLAREADATE',
    'begin_date': 'BEGINDATE',
    'end_date': 'ENDDATE',
    'peo_uni_code': 'PSCODE',
    'name': 'PSNAME',
    'post': 'POST',
    'sex_par': 'GENDER',
    'birth_day': 'BIRTHDATE',
    'high_edu': 'DEGREE',
    'back_gro': 'CV',
    'data_source': 'DATASOURCE',
    'remark': 'MEMO',
}

FundCloseOpenMap = {
    'cfund_uni_code': 'SECURITYID',
    'cfund_name': 'CFSNAME',
    'ofund_uni_code': 'OFSECURITYID',
    'ofund_name': 'OFSNAME',
    'suspend_beg_date': 'DELISTBEGDATE',
    'announcement_date': 'DECLAREDATE',
    'meeting_date': 'MEETDATE',
    'decision_result': 'RESULT',
    'resumption_date': 'RESUMEDATE',
    'cfund_end_list_date': 'CFENDLISTDATE',
    'sub_begin_date': 'SUBBEGINDATE',
    'sub_end_date': 'SUBFREEZEDATE',
    'fund_conversion_date': 'FDCVTDATE',
    'open_sub_date': 'OPENSUBDATE',
    'open_redem_date': 'OPENREDEDATE',
    'cfund_share': 'CFSHARE',
    'cfund_share_after_split': 'CFSHAREAFSPLIT',
    'centralized_sub_share': 'SUBSHARE',
    'centralized_sub_conversion_share': 'SUBANDCVTSHARE',
}

FundInherentInvestMap = {
    'sec_uni_code': 'SECURITYID',
    'announcement_date': 'DECLAREDATE',
    'update_date': 'UPDATETDATE',
    'mana_comp_uni_code': 'COMPCODE',
    'mana_comp_name': 'COMPNAME',
    'begin_date': 'BEGINDATE',
    'end_date': 'ENDDATE',
    'invest_type': 'INVESTTYPE',
    'sub_redem_amount': 'REDAMT',
    'app_rate': 'APPRATE',
    'app_rate_unit': 'APPUNIT',
    'invest_period': 'INVESTPERIOD',
    'remark': 'MEMO',
}

FundHolderMeetingMap = {
    'sec_uni_code': 'SECURITYID',
    'announcement_date': 'DECLAREDATE',
    'update_date': 'UPDATEDATE',
    'meeting_type': 'MEETINGTYPE',
    'meeting_year': 'YEARS',
    'meeting_number': 'NUMBER',
    'convening_form': 'CONVENINGWAY',
    'convening_place': 'CONVENINGPLACE',
    'meeting_theme': 'THEME',
    'decision_result': 'DECISSION',
    'convening_announcement_date': 'ANNOUNCEDATE',
    'record_date': 'RECORDDATE',
    'pre_record_beg_date': 'PREREGBEG',
    'pre_record_end_date': 'PREREGEND',
    'convening_beg_date': 'CONVENINGBEG',
    'convening_end_date': 'CONVENINGEND',
    'decision_announcement_date': 'RESOLDATE',
    'continuous_suspend_beg_date': 'CONTINUSUSPBEG',
    'continuous_suspend_end_date': 'CONTINUSUSPEND',
    'remark': 'MEMO',
}

FundPPQualificationMap = {
    'org_uni_code': 'COMPCODE',
    'org_name': 'COMPNAME',
    'org_type': 'COMPTYPE',
    'end_date': 'ENDDATE',
    'total_staff': 'WORKFORCE',
    'fund_practice_qualification': 'FDQUCATION',
    'fund_sale_practice_qualification': 'FDSQUCATION',
    'other_practice_qualification': 'OTHQUCATION',
    'pe_vc_practice_qualification': 'PEVCQUCATION',
    'risk_control_head': 'PERRISKCONTROL',
    'fund_invest_advisor': 'FUNDINADVISOR',
    'fund_manager': 'MANAGERNAME',
    'investment_manager': 'INVESTMANAGER',
    'investment_director': 'INVESTDIRECTOR',
}

FundXRFactorMap = {
    'sec_uni_code': 'SECURITYID',
    'announcement_date': 'PUBLISHDATE',
    'sec_code': 'SYMBOL',
    'currency_type': 'CUR',
    'bonus_type': 'BONUSTYPE',
    'bonus_year': 'BONUSYEAR',
    'dividend_serial_number': 'NUM',
    'nav_xdr_date': 'AFXDRNAVDATE',
    'unit_div': 'UNITPTAXDEV',
    'split_conversion_ratio': 'SHARERT',
}

FundMarketScaleMap = {
    'announcement_date': 'DECLAREDATE',
    'end_date': 'ENDDATE',
    'stat_agency': 'COMPNAME',
    'sec_type': 'SEC_TYPE',
    'fund_type': 'SCALENAME',
    'fund_nav': 'MARKETNAV',
    'fund_quantity': 'QUANTITY',
    'fund_share': 'SHARES',
}

FundKeeperFundMap = {
    'end_date': 'ENDDATE',
    'fund_keeper_code': 'KEEPERCODE',
    'fund_keeper_name': 'KEEPERNAME',
    'fund_quantity': 'FDNUMBER',
    'fund_share': 'FDSHARE',
    'fund_nav': 'FDASS',
    'open_fund_quantity': 'OPFDNUM',
    'open_fund_share': 'OPFDSHA',
    'open_fund_nav': 'OPFDASS',
    'closed_fund_quantity': 'CLFDNUM',
    'closed_fund_share': 'CLFDSHA',
    'closed_fund_nav': 'CLFDASS',
}

FundSDRateMap = {
    'sec_uni_code': 'SECURITYID',
    'announcement_date': 'DECLAREDATE',
    'begin_date': 'BEGINDATE',
    'end_date': 'ENDDATE',
    'std_dis_rate': 'CONVERSION',
}

FundSIHShareMap = {
    'sec_uni_code': 'SECURITYID',
    'announcement_date': 'DECLAREDATE',
    'report_type': 'REPORTTYPE',
    'investor_type': 'INVESTORTYPE',
    'serial_number': 'RN',
    'share_exs_20pct_beg_date': 'BEGINDATE',
    'share_exs_20pct_end_date': 'ENDDATE',
    'ini_fund_share': 'INITIALAMT',
    'drp_app_share': 'BSHARE',
    'drp_redem_share': 'RSHARE',
    'final_fund_share': 'FINHOLDSHARE',
    'final_fund_share_ratio': 'FINSHARERATIO',
}

FundLeverageMap = {
    'sec_uni_code': 'SECURITYID',
    'trade_date': 'TRADEDATE',
    'share_leverage': 'SHARELEVERAGE',
    'nav_leverage': 'NAVLEVERAGE',
    'price_leverage': 'PRIXLEVERAGE',
    'bfund_unit_nav': 'BFUNDNAV',
    'bfund_close_price': 'BFUNDCLOSE',
    'bfund_ratio': 'BFUNDRATIO',
    'master_fund_unit_nav': 'MASTERNAV',
    'master_fund_ratio': 'MASTERRATIO',
    'dis_master_fall_ratio': 'LOWBASERATIO',
}

BondsSecuritiesRepurMap = {
    'com_uni_code': 'COMPCODE',
    'sec_fname': 'SENAME',
    'sec_name': 'SESNAME',
    'sec_code': 'SYMBOL',
    'abc_code': 'ABC_CODE',
    'sec_type': 'SEC_TYPE',
    'sec_small_type': 'SETYPE',
    'sec_short_name': 'SESPELL',
    'ipo_status': 'LISTSTATUS',
    'security_type': 'EXCHANGE',
    'ipo_date': 'BEGINDATE',
    'end_date': 'ENDDATE',
    'currency_type': 'CUR',
    'come_source': 'COME_SOURCE',
    'source_id': 'SOURCE_ID',
}

FundTrusteeMap = {
    'end_date': 'ENDDATE',
    'fund_trustee_code': 'TRUSTEECODE',
    'fund_trustee_name': 'TRUSTEENAME',
    'fund_quantity': 'FDNUMBER',
    'fund_share': 'FDSHARE',
    'fund_nav': 'FDASS',
    'open_fund_quantity': 'OPFDNUM',
    'open_fund_share': 'OPFDSHA',
    'open_fund_nav': 'OPFDASS',
    'closed_fund_quantity': 'CLFDNUM',
    'closed_fund_share': 'CLFDSHA',
    'closed_fund_nav': 'CLFDASS',
}

FundDiscountMap = {
    'sec_uni_code': 'SECURITYID',
    'trade_date': 'TRADEDATE',
    'close_price': 'TCLOSE',
    'end_date': 'ENDDATE',
    'unit_nav': 'UNITNAV',
    'discount': 'DISCOUNT',
    'discount_rate': 'DISCOUNTRATE',
}

FundMangerStatMap = {
    'peo_uni_code': 'PSCODE',
    'fund_manager_name': 'PSNAME',
    'fund_count': 'TOTCOUNT',
    'present_comp_code': 'KEEPERNAME',
    'present_comp_name': 'KEEPERNAME',
    'present_comp_beg_date': 'INCUMBTBEG',
    'present_comp_fund_count': 'CURFCOUNT',
}

FundMangerPrefMap = {
    'sec_uni_code': 'SECURITYID',
    'fund_sname': 'FDSNAME',
    'fund_type': 'RANKTYPE',
    'peo_uni_code': 'MANAGERCODE',
    'fund_manager_name': 'MANAGERNAME',
    'is_incumbent': 'ISINCUMBENT',
    'begin_date': 'BEGINDATE',
    'end_date': 'ENDDATE',
    'nav_growth_rate': 'NAVRTO',
    'benchmark_growth_rate': 'BENCHMARKRTO',
    'return_rate': 'TENUREYIELD',
    'annual_yield': 'TENUREYIELDYR',
    'all_rank': 'ALLRANK',
    'all_avg_yield': 'ALLAVGYIELD',
    'class_rank': 'CLASSRANK',
    'class_type': 'class_type',
    'rank_type_avg_yield': 'RTYPEAVGYIELD',
}

FundNavReturnMap = {
    'sec_uni_code': 'SECURITYID',
    'end_date': 'ENDDATE',
    'unit_nav': 'UNITNAV',
    'cumu_unit_nav': 'UNITACCNAV',
    'adj_unit_nav': 'REPAIRUNITNAV',
    'rise_rate': 'NAVGRTD',
    'cumu_unit_nav_rise_rate': 'UNITACCNAVGR',
    'currency_type': 'CUR',
    'nav_return_l_1w': 'NAVGRL1W',
    'nav_return_l_1m': 'NAVGRL1M',
    'nav_return_l_3m': 'NAVGRL3M',
    'nav_return_l_6m': 'NAVGRL6M',
    'nav_return_l_1y': 'NAVGRL1Y',
    'nav_return_l_2y': 'NAVGRL2Y',
    'nav_return_l_3y': 'NAVGRL3Y',
    'nav_return_l_5y': 'NAVGRL5Y',
    'nav_return_t_1w': 'NAVGRT1W',
    'nav_return_t_1m': 'NAVGRT1M',
    'nav_return_t_1q': 'NAVGRTQ',
    'nav_return_t_1y': 'NAVGRT1Y',
    'nav_return_found': 'NAVGRLIST',
}

FundBenchmarkYieldMap = {
    'sec_uni_code': 'SECURITYID',
    'end_date': 'BENCHDATE',
    'yield': 'YIELD',
    'index_value': 'INEDXVALUE'
}


"""
字段取值映射关系，按照目标字段
"""

InstitutionsCompanyValueMap = {
    'org_type': {
        'A01': 1013001001,
        'A02': 1013001001002,
        'B01': 1013001007,
        'B02': 1013001005,
        'B03': 1013001006,
        'C01': 1013002001,
        'C02': 1013002002,
        'C03': 1013002003,
        'C04': 1013002007,
        'C05': 1013002005,
        'C06': 1013024,
        'C07': 1013002006,
        'C08': 1013002008,
        'C09': 1013002004,
        'C10': 1013002012,
        'C11': 1013002011,
        'C12': 1013020,
        'C99': 1013024,
        'D01': 1013005,
        'D02': 1013008,
        'D03': 1013010,
        'D04': 1013024,
        'D05': 1013002011,
        'D06': 1013024,
        'D09': 1013024,
        'E01': 1013006,
        'E02': 1013007,
        'E03': 1013027,
        'E04': 1013030,
        'E05': 1013009,
        'E06': 1013021,
        'F01': 1013003,
        'F02': 1013003,
        'F03': 1013003,
        'F04': 1013008,
        'F05': 1013004,
        'F06': 1013004,
        'F07': 1013004,
        'F08': 1013003,
        'F09': 1013031,
        'G01': 1013001011,
        'G02': 1013014,
        'H01': 1013024,
        'H09': 1013024,
        'Z01': 1013041,
        'Z02': 1013001,
        'Z09': 1013041,
    },
    'com_nature': {
        '001001': 1008002,
        '001002': 1008010,
        '001003': 1008005,
        '001004': 1008021,
        '001005': 1008022,
        '001006': 1008001,
        '002001': 1008017,
        '003001': 1008018,
        '99': 1008011,
        '001007': 1008003,
    },
    'currency_type': {
        'SQL': ('data_center', "select system_uni_code from system_const where fat_name='货币类型' and status!='9' and system_disc=%s limit 1;", 0)
    }
}

FundSecuritiesValueMap = {
    'security_type': {
        '001002': 1003002,
        '001003': 1003001,
        '000091': 1003024,
    },
    'sec_small_type': {
        '301': 1004003002,
        '302': 1004003003,
    },
    'ipo_status': {
        '1': 1002007,
        '2': 1002006,
        '0': 1002003,
        '3': 1002013,
    },
    'currency_type': {
        'SQL': ('data_center', "select system_uni_code from system_const where fat_name='货币类型' and status!='9' and system_disc=%s limit 1;", 0)
    },
    'com_uni_code': {
        'SQL': ('data_center', "select com_uni_code from org_basic_info where source_id=%s and status!='9' limit 1;", 0)
    }
}

FundInfoValueMap = {
    'sec_uni_code': {
        'SQL': ('data_center', '''select sec_uni_code from sec_basic_info where source_id=%s and status!='9' and sec_type=1004003 and sec_small_type in(1004003002,1004003003) limit 1;''', 0)
    },
    'mana_uni_code': {
        'SQL': ('data_center', '''select com_uni_code from org_basic_info where org_name=%s and status!='9' limit 1;''', 0)
    },
    'cust_uni_code': {
        'SQL': ('data_center', '''select com_uni_code from org_basic_info where org_name=%s and status!='9' limit 1;''', 0)
    },
    'operate_period_unit': {
        '1': 1524004,
        '2': 1524005,
        '3': 1524006,
        '4': 1524008,
    },
    'issue_mode': {
        '11': 1513034,
        '21': 1513005,
        '22': 1513032,
        '23': 1513031,
        '29': 1513031,
    },
    'invst_cur_type': {
        'SQL': ('data_center', "select system_uni_code from system_const where fat_name='货币类型' and status!='9' and system_disc=%s limit 1;", 0)
    },
    'exchange': {
        '001002': 1003002,
        '001003': 1003001,
        '000091': 1003024,
    },
    'nav_pub_type': {
        '1': 1902001,
        '2': 1902002,
    }
}

FundBenchMarkValueMap = {
    'sec_uni_code': {
        'SQL': ('data_center', '''select sec_uni_code from sec_basic_info where source_id=%s and status!='9' and sec_type=1004003 and sec_small_type in(1004003002,1004003003) limit 1;''', 0)
    },
    'yield_period': {
        '1': 1524004,
        '2': 1524005,
        '3': 1524006,
        '4': 1524007,
        '5': 1524009,
        '6': 1524008
    },
}

FundNavValueMap = {
    'sec_uni_code': {
        'SQL': ('data_center', '''select sec_uni_code from sec_basic_info where source_id=%s and status!='9' and sec_type=1004003 and sec_small_type in(1004003002,1004003003) limit 1;''', 0)
    },
    'currency_type': {
        'SQL': ('data_center', "select system_uni_code from system_const where fat_name='货币类型' and status!='9' and system_disc=%s limit 1;", 0)
    },
}

FundNavCurValueMap = {
    'sec_uni_code': {
        'SQL': ('data_center', '''select sec_uni_code from sec_basic_info where source_id=%s and status!='9' and sec_type=1004003 and sec_small_type in(1004003002,1004003003) limit 1;''', 0)
    },
    'special_sign': {
        '1': 1903001,
        '2': 1903002,
        '3': 1903003,
        '4': 1903004,
    },
    'announced_returns_unit': {
        '1': 1904001,
        '2': 1904002,
        '3': 1904003,
    }
}

FundNavBenchmarkValueMap = {
    'sec_uni_code': {
        'SQL': ('data_center', '''select sec_uni_code from sec_basic_info where source_id=%s and status!='9' and sec_type=1004003 and sec_small_type in(1004003002,1004003003) limit 1;''', 0)
    },
    'report_type': {
        '1': 1015037001,
        '2': 1015037002,
    },
    'stat_period': {
        '1': 1905001,
        '2': 1905002,
        '3': 1905003,
        '4': 1905004,
        '5': 1905005,
        '6': 1905006,
        '7': 1905007,
        '8': 1905008
    }
}

PlateInfoValueMap = {
    'sec_uni_code': {
        'SQL': ('data_center', '''select sec_uni_code from sec_basic_info where source_id=%s and status!='9' and sec_type=1004003 and sec_small_type in(1004003002,1004003003) limit 1;''', 0)
    },
    'org_uni_code': {
        'SQL': ('data_center', '''select com_uni_code from sec_basic_info where source_id=%s and status!='9' and sec_type=1004003 and sec_small_type in(1004003002,1004003003) limit 1;''', 0)
    },
    'plate_code': {
        '100101': '1002001', '100201': '1002002', '100301': '1002003', '100401': '1002004', '22021402': '1003002014002',
        '100701': '1002006', '110101':'1004001001001', '110102':'1004001001002', '110103':'1004001001003',
        '110104':'1004001001004', '110201':'1004001002001', '110202':'1004001002002', '110203':'1004001002003',
        '110204':'1004001002004', '110205':'1004001002005', '110301':'1004001003001', '110302':'1004001003002',
        '110303':'1004001003003', '110304':'1004001003004', '110305':'1004001003005', '110401':'1004001004001',
        '110501':'1004001005001', '110601':'1004001006001', '110602':'1004001006002', '110603':'1004001006003',
        '110604':'1004001006004', '110605':'1004001006005', '120101':'1004002001001', '120112':'1004002001012',
        '120201':'1004002002001', '120212':'1004002002012', '120213':'1004002002013', '130101':'1004003001',
        '130201':'1004003002', '130301':'1004003003', '190101':'1004019001', '190201':'1004019002', '190301':'1004019003',
        '190401':'1004019004', '190501':'1004019005', '190601':'1004019006', '190701':'1004019007', '190801':'1004019008',
        '190901':'1004019009', '191001':'1004019010', '191101':'1004019011', '191201':'1004019012', '191301':'1004019013',
        '191401':'1004019014', '191501':'1004019015', '191601':'1004019016', '191701':'1004019017', '191801':'1004019018',
        '191901':'1004019019', '192001':'1004019020', '192101':'1004019021', '192201':'1004019022', '192202':'1004019023',
        '192203':'1004019024', '192301':'1004019025', '192401':'1004019026', '192501':'1004019027', '210101':'1004021001',
        '210201':'1004021002', '210301':'1004021003', '210401':'1004021004', '210501':'1004021005', '210601':'1004021006',
        '192601': '1004019028', '192701':'1004019028', '210701':'1004021007', '210801':'1004021007'
        , '2201':'1003001001'
        , '2202':'1003001002'
        , '2203':'1003001003'
        , '2204':'1003001004'
        , '2205':'1003001005'
        , '2206':'1003001006'
        , '2210':'1003001010'
        , '220101':'1003001001001'
        , '220102':'1003001001002'
        , '220107':'1003001001007'
        , '220108':'1003001001008'
        , '220109':'1003001001009'
        , '220110':'1003001001010'
        , '220120':'1003001001020'
        , '220201':'1003001002001'
        , '220202':'1003001002002'
        , '220203':'1003001002003'
        , '220204':'1003001002004'
        , '220205':'1003001002005'
        , '220206':'1003001002006'
        , '220207':'1003001002007'
        , '220208':'1003001002008'
        , '220209':'1003001002009'
        , '220210':'1003001002010'
        , '220211':'1003001002011'
        , '220212':'1003001002012'
        , '220213':'1003001002013'
        , '220214':'1003001002014'
        , '220219':'1003001002019'
        , '220220':'1003001002020'
        , '220221':'1003001002021'
        , '220222':'1003001002022'
        , '220223':'1003001002023'
        , '220224':'1003001002024'
        , '220229':'1003001002029'
        , '220301':'1003001003001'
        , '220302':'1003001003002'
        , '220303':'1003001003003'
        , '220304':'1003001003004'
        , '220307':'1003001003007'
        , '220308':'1003001003008'
        , '220309':'1003001003009'
        , '220310':'1003001003010'
        , '220311':'1003001003011'
        , '220320':'1003001003020'
        , '220321':'1003001003021'
        , '220401':'1003001004001'
        , '220402':'1003001004002'
        , '220409':'1003001004009'
        , '220501':'1003001005001'
        , '220502':'1003001005002'
        , '220503':'1003001005003'
        , '220509':'1003001005009'
        , '220601':'1003001006001'
        , '220602':'1003001006002'
        , '220603':'1003001006003'
        , '220609':'1003001006009'
        , '221001':'1003001010001'
        , '221002':'1003001010002'
        , '221003':'1003001010003'
        , '221004':'1003001010004'
        , '221009':'1003001010009'
        , '22010101':'1003001001001001'
        , '22010102':'1003001001001002'
        , '22010103':'1003001001001003'
        , '22010201':'1003001001002001'
        , '22010203':'1003001001002003'
        , '22010209':'1003001001002009'
        , '22010210':'1003001001002010'
        , '22010701':'1003001001007001'
        , '22010702':'1003001001007002'
        , '22010703':'1003001001007003'
        , '22010704':'1003001001007004'
        , '22010705':'1003001001007005'
        , '22010707':'1003001001007007'
        , '22010708':'1003001001007008'
        , '22010801':'1003001001008001'
        , '22010802':'1003001001008002'
        , '22010901':'1003001001009001'
        , '22011001':'1003001001010001'
        , '22012001':'1003001001020001'
        , '22020101':'1003001002001001'
        , '22020102':'1003001002001002'
        , '22020103':'1003001002001003'
        , '22020104':'1003001002001004'
        , '22020201':'1003001002002001'
        , '22020202':'1003001002002002'
        , '22020203':'1003001002002003'
        , '22020301':'1003001002003001'
        , '22020302':'1003001002003002'
        , '22020303':'1003001002003003'
        , '22020304':'1003001002003004'
        , '22020305':'1003001002003005'
        , '22020306':'1003001002003006'
        , '22020307':'1003001002003007'
        , '22020308':'1003001002003008'
        , '22020401':'1003001002004001'
        , '22020402':'1003001002004002'
        , '22020501':'1003001002005001'
        , '22020502':'1003001002005002'
        , '22020601':'1003001002006001'
        , '22020602':'1003001002006002'
        , '22020701':'1003001002007001'
        , '22020801':'1003001002008001'
        , '22020802':'1003001002008002'
        , '22020803':'1003001002008003'
        , '22020804':'1003001002008004'
        , '22020901':'1003001002009001'
        , '22021001':'1003001002010001'
        , '22021101':'1003001002011001'
        , '22021102':'1003001002011002'
        , '22021201':'1003001002012001'
        , '22021202':'1003001002012002'
        , '22021301':'1003001002013001'
        , '22021302':'1003001002013002'
        , '22021401':'1003001002014001'
        , '22021402':'1003001002014002'
        , '22021403':'1003001002014003'
        , '22021901':'1003001002019001'
        , '22022001':'1003001002020001'
        , '22022101':'1003001002021001'
        , '22022201':'1003001002022001'
        , '22022301':'1003001002023001'
        , '22022401':'1003001002024001'
        , '22022901':'1003001002029001'
        , '22022909':'1003001002029009'
        , '22030101':'1003001003001001'
        , '22030102':'1003001003001002'
        , '22030201':'1003001003002001'
        , '22030202':'1003001003002002'
        , '22030203':'1003001003002003'
        , '22030204':'1003001003002004'
        , '22030205':'1003001003002005'
        , '22030206':'1003001003002006'
        , '22030301':'1003001003003001'
        , '22030302':'1003001003003002'
        , '22030401':'1003001003004001'
        , '22030402':'1003001003004002'
        , '22030701':'1003001003007001'
        , '22030702':'1003001003007002'
        , '22030801':'1003001003008001'
        , '22030802':'1003001003008002'
        , '22030901':'1003001003009001'
        , '22031001':'1003001003010001'
        , '22031002':'1003001003010002'
        , '22031101':'1003001003011001'
        , '22031102':'1003001003011002'
        , '22031103':'1003001003011003'
        , '22031104':'1003001003011004'
        , '22031105':'1003001003011005'
        , '22031106':'1003001003011006'
        , '22032001':'1003001003020001'
        , '22032002':'1003001003020002'
        , '22032101':'1003001003021001'
        , '22032102':'1003001003021002'
        , '22032103':'1003001003021003'
        , '22032105':'1003001003021005'
        , '22040101':'1003001004001001'
        , '22040102':'1003001004001002'
        , '22040201':'1003001004002001'
        , '22040901':'1003001004009001'
        , '22050101':'1003001005001001'
        , '22050102':'1003001005001002'
        , '22050201':'1003001005002001'
        , '22050203':'1003001005002003'
        , '22050204':'1003001005002004'
        , '22050301':'1003001005003001'
        , '22050901':'1003001005009001'
        , '22060101':'1003001006001001'
        , '22060102':'1003001006001002'
        , '22060201':'1003001006002001'
        , '22060202':'1003001006002002'
        , '22060301':'1003001006003001'
        , '22060302':'1003001006003002'
        , '22060901':'1003001006009001'
        , '22060902':'1003001006009002'
        , '22060903':'1003001006009003'
        , '22060904':'1003001006009004'
        , '22060908':'1003001006009008'
        , '22060909':'1003001006009009'
        , '22100101':'1003001010001001'
        , '22100201':'1003001010002001'
        , '22100301':'1003001010003001'
        , '22100401':'1003001010004001'
        , '22100402':'1003001010004002'
        , '22100403':'1003001010004003'
        , '22100404':'1003001010004004'
        , '22100901':'1003001010009001'
    }
}

FundRateValueMap = {
    'sec_uni_code': {
        'SQL': ('data_center', '''select sec_uni_code from sec_basic_info where source_id=%s and status!='9' and sec_type=1004003 and sec_small_type in(1004003002,1004003003) limit 1;''', 0)
    },
    'rate_type1': {
        '01': 1907001001,
        '02': 1907001002,
        '03': 1907001003,
        '04': 1907001004,
        '05': 1907001005,
        '06': 1907001006,
        '11': 1907001007,
        '13': 1907001008,
        '14': 1907001009,
    },
    'rate_type2': {
        '0101': 1907001001001,
        '0102':	1907001001002,
        '0201':	1907001002001,
        '0301':	1907001003001,
        '0401':	1907001004001,
        '0402':	1907001004002,
        '0403':	1907001004003,
        '0404':	1907001004004,
        '0405':	1907001004005,
        '0501':	1907001005001,
        '0502':	1907001005002,
        '0505':	1907001005003,
        '0506':	1907001005004,
        '0509':	1907001005005,
        '0510':	1907001005006,
        '0512':	1907001005007,
        '0513':	1907001005008,
        '0514':	1907001005009,
        '0515':	1907001005010,
        '0516':	1907001005011,
        '0601':	1907001006001,
        '0604':	1907001006002,
        '0605':	1907001006003,
        '0607':	1907001006004,
        '1101':	1907001007001,
        '1301':	1907001008001,
        '1401':	1907001009001,
    },
    'rate_calc_mode': {
        '1': 1907004001,
        '2': 1907004002,
    },
    'currency_type': {
        'SQL': ('data_center', "select system_uni_code from system_const where fat_name='货币类型' and status!='9' and system_disc=%s limit 1;", 0)
    },
    'rate_unit': {
        '1': 1907005001,
        '2': 1907005002,
        '3': 1907005003,
    },
    'hold_period_unit': {
        '1': 1524008,
        '2': 1524004,
        '3': 1524006,
        '9': 1524010,
    }
}

ClosedFundInfoValueMap = {
    'sec_uni_code': {
        'SQL': ('data_center', '''select sec_uni_code from sec_basic_info where source_id=%s and status!='9' and sec_type=1004003 and sec_small_type in(1004003002,1004003003) limit 1;''', 0)
    },
    'expo_exchange': {
        '001002': 1003002,
        '001003': 1003001,
        '000091': 1003024,
    }
}

GuaranteedFundInfoValueMap = {
    'sec_uni_code': {
        'SQL': ('data_center', '''select sec_uni_code from sec_basic_info where source_id=%s and status!='9' and sec_type=1004003 and sec_small_type in(1004003002,1004003003) limit 1;''', 0)
    },
    'guaranteed_fee_rate': {  # 连接配置， SQL语句， 默认值
        'SQL': ('funds', 'select RATEMAXCOST from TQ_FD_RATECHG where SECURITYID=%s and RATENAME2=1201 order by BEGINDATE desc limit 1;', None),
    },
    'warrantor': {
        'SQL': ('funds', 'select COMPNAME from TQ_FD_PARTY where SECURITYID=%s and PARTYTYPE=2 order by BEGINDATE desc limit 1;', None),
    },
}

GuaranteedFundCycleValueMap = {
    'sec_uni_code': {
        'SQL': ('data_center', '''select sec_uni_code from sec_basic_info where source_id=%s and status!='9' and sec_type=1004003 and sec_small_type in(1004003002,1004003003) limit 1;''', 0)
    },
    'date_type': {
        '5': 1908001,
        '6': 1908002
    }
}

ETFBasicInfoValueMap = {
    'sec_uni_code': {
        'SQL': ('data_center', '''select sec_uni_code from sec_basic_info where source_id=%s and status!='9' and sec_type=1004003 and sec_small_type in(1004003002,1004003003) limit 1;''', 0)
    },
    'onl_cash_offering_code': {
        'SQL': ('funds', 'select MAPCODE from TQ_OA_SECURITYMAP where SECURITYID=%s and SETYPE in(301,302) and MAPTYPE=8 limit 1;', None),
    },
    'app_redem_code': {
        'SQL': ('funds', 'select MAPCODE from TQ_OA_SECURITYMAP where SECURITYID=%s and SETYPE in(301,302) and MAPTYPE=7 limit 1;', None),
    },
    'app_redem_sname': {
        'SQL': ('funds', 'select MAPNAME from TQ_OA_SECURITYMAP where SECURITYID=%s and SETYPE in(301,302) and MAPTYPE=7 limit 1;', None),
    },
    'exchange_code': {
        'SQL': ('funds', 'select MAPCODE from TQ_OA_SECURITYMAP where SECURITYID=%s and SETYPE in(301,302) and MAPTYPE=15 limit 1;', None),
    },
    'exchange_sname': {
        'SQL': ('funds', 'select MAPNAME from TQ_OA_SECURITYMAP where SECURITYID=%s and SETYPE in(301,302) and MAPTYPE=15 limit 1;', None),
    },
    'onl_cash_sub_start_date': {
        'SQL': ('funds', 'select BEGINDATE from TQ_FD_FUNDSDATE where SECURITYID=%s and DTYPE=2 order by BEGINDATE desc limit 1;', None),
    },
    'onl_cash_sub_end_date': {
        'SQL': ('funds', 'select ENDDATE from TQ_FD_FUNDSDATE where SECURITYID=%s and DTYPE=2 order by ENDDATE desc limit 1;', None),
    },
    'onl_cash_sub_lower': {
        'SQL': ('funds', '''select RATEMAXCOST from TQ_FD_RATECHG where SECURITYID=%s and RATENAME2='0813' limit 1;''', None),
    },
    'onl_cash_sub_upper': {
        'SQL': ('funds', '''select RATEMAXCOST from TQ_FD_RATECHG where SECURITYID=%s and RATENAME2='1006' limit 1;''', None),
    },
    'offl_cash_sub_start_date': {
        'SQL': ('funds', '''select BEGINDATE from TQ_FD_FUNDSDATE where SECURITYID=%s and DTYPE=3 order by BEGINDATE desc limit 1;''', None),
    },
    'offl_cash_sub_end_date': {
        'SQL': ('funds', '''select ENDDATE from TQ_FD_FUNDSDATE where SECURITYID=%s and DTYPE=3 order by ENDDATE desc limit 1;''', None),
    },
    'offl_cash_sub_lower': {
        'SQL': ('funds', '''select min(RATEMAXCOST) RATEMAXCOST from TQ_FD_RATECHG where SECURITYID=%s and RATENAME2='0815' limit 1;''', None),
    },
    'offl_sec_sub_start_date': {
        'SQL': ('funds', '''select BEGINDATE from TQ_FD_FUNDSDATE where SECURITYID=%s and DTYPE=4 order by BEGINDATE desc limit 1;''', None),
    },
    'offl_sec_sub_end_date': {
        'SQL': ('funds', '''select ENDDATE from TQ_FD_FUNDSDATE where SECURITYID=%s and DTYPE=4 order by ENDDATE desc limit 1;''', None),
    },
    'offl_sec_sub_lower': {
        'SQL': ('funds', '''select RATEMAXCOST from TQ_FD_RATECHG where SECURITYID=%s and RATENAME2='0817' limit 1;''', None),
    }
}

LOFBasicInfoValueMap = {
    'sec_uni_code': {
        'SQL': ('data_center', '''select sec_uni_code from sec_basic_info where source_id=%s and status!='9' and sec_type=1004003 and sec_small_type in(1004003002,1004003003) limit 1;''', 0)
    }
}

MoneyMarketFundBasicInfoValueMap = {
    'sec_uni_code': {
        'SQL': ('data_center', '''select sec_uni_code from sec_basic_info where source_id=%s and status!='9' and sec_type=1004003 and sec_small_type in(1004003002,1004003003) limit 1;''', 0)
    },
    'profit_pay_type': {
        '1': 1909001,
        '2': 1909002,
        '3': 1909003,
        '4': 1909004,
        '5': 1909005
    },
    'share_tras_type': {
        '01': 1910001,
        '02': 1910002
    }
}

FundPriceDayValueMap = {
    'sec_uni_code': {
        'SQL': ('data_center', '''select sec_uni_code from sec_basic_info where source_id=%s and status!='9' and sec_type=1004003 and sec_small_type in(1004003002,1004003003) limit 1;''', 0)
    },
    'exchange': {
        '001002': 1003002,
        '001003': 1003001,
        '000091': 1003024,
    }
}

FundPriceWeekValueMap = {
    'sec_uni_code': {
        'SQL': ('data_center', '''select sec_uni_code from sec_basic_info where source_id=%s and status!='9' and sec_type=1004003 and sec_small_type in(1004003002,1004003003) limit 1;''', 0)
    },
    'sename': {
        'SQL': ('data_center', '''select sec_name from sec_basic_info where source_id=%s and status!='9' and sec_type=1004003 and sec_small_type in(1004003002,1004003003) limit 1;''', None)
    },
    'exchange': {
        '001002': 1003002,
        '001003': 1003001,
        '000091': 1003024,
    }
}

FundPriceMonthValueMap = {
    'sec_uni_code': {
        'SQL': ('data_center', '''select sec_uni_code from sec_basic_info where source_id=%s and status!='9' and sec_type=1004003 and sec_small_type in(1004003002,1004003003) limit 1;''', 0)
    },
    'sename': {
        'SQL': ('data_center', '''select sec_name from sec_basic_info where source_id=%s and status!='9' and sec_type=1004003 and sec_small_type in(1004003002,1004003003) limit 1;''', None)
    },
    'exchange': {
        '001002': 1003002,
        '001003': 1003001,
        '000091': 1003024,
    }
}

FundPriceYearValueMap = {
    'sec_uni_code': {
        'SQL': ('data_center', '''select sec_uni_code from sec_basic_info where source_id=%s and status!='9' and sec_type=1004003 and sec_small_type in(1004003002,1004003003) limit 1;''', 0)
    },
    'sename': {
        'SQL': ('data_center', '''select sec_name from sec_basic_info where source_id=%s and status!='9' and sec_type=1004003 and sec_small_type in(1004003002,1004003003) limit 1;''', None)
    },
    'exchange': {
        '001002': 1003002,
        '001003': 1003001,
        '000091': 1003024,
    }
}

FundDividendValueMap = {
    'sec_uni_code': {
        'SQL': ('data_center', '''select sec_uni_code from sec_basic_info where source_id=%s and status!='9' and sec_type=1004003 and sec_small_type in(1004003002,1004003003) limit 1;''', 0)
    },
    'currency_type': {
        'SQL': ('data_center', "select system_uni_code from system_const where fat_name='货币类型' and status!='9' and system_disc=%s limit 1;", 0)
    },
    'default_dividend_type': {
        '1': 1912001,
        '2': 1912002,
        '3': 1912003,
    },
    'dividend_status': {
        1: 1911001,
        2: 1911002,
    }
}

MoneyMarketFundDividendValueMap = {
    'sec_uni_code': {
        'SQL': ('data_center', '''select sec_uni_code from sec_basic_info where source_id=%s and status!='9' and sec_type=1004003 and sec_small_type in(1004003002,1004003003) limit 1;''', 0)
    },
    'dividend_type': {
        '02': 1912001,
        '01': 1912002,
        '99': 1912003,
        '03': 1912004,
    }
}

FundManagerBasicInfoValueMap = {
    'sec_uni_code': {
        'SQL': ('data_center', '''select sec_uni_code from sec_basic_info where source_id=%s and status!='9' and sec_type=1004003 and sec_small_type in(1004003002,1004003003) limit 1;''', 0)
    },
    'peo_uni_code': {
        'SQL': ('data_center', '''select peo_uni_code from peo_basic_info where come_source='zh-data' and status!='9' and source_id=%s limit 1;''', None)
    },
}

PeopleBasicInfoValueMap = {
    'poli_status': {
        '1': u'中共党员',
        '2': u'中共预备党员',
        '3': u'共青团员',
        '4': u'民革党员',
        '5': u'民盟盟员',
        '6': u'民建会员',
        '7': u'民进会员',
        '8': u'农工党党员',
        '9': u'致公党党员',
        '10': u'九三学社社员',
        '11': u'台盟盟员',
        '12': u'无党派民主人士',
        '13': u'群众',
        '99': u'其他'
    },
    'high_edu': {
        '1': 1010001,
        '2': 1010002,
        '8': 1010003,
        '3': 1010004,
        '4': 1010005,
        '5': 1010006,
        '6': 1010007,
        '7': 1010008,
        '99': 1010000,
    }
}

InstitutionsChangeValueMap = {
    'org_uni_code': {
        'SQL': ('data_center', "select com_uni_code from org_basic_info where source_id=%s and status!='9' limit 1;", None)
    },
    'change_type': {
        '1': u'法人代表',
        '2': u'董事长',
        '3': u'总经理',
        '4': u'公司名称',
        '5': u'组织形式',
        '6': u'经营范围',
        '7': u'注册地址',
        '8': u'办公地址',
        '9': u'行业分类',
        '10': u'营业期限',
        '11': u'境内会计师事务所',
        '12': u'境外会计师事务所',
        '13': u'律师事务所',
        '14': u'主营业务',
        '15': u'英文名称',
        '16': u'所属地区变动',
        '17': u'公司秘书',
        '18': 'CEO',
        '19': 'CFO',
        '20': 'COO',
        '21': u'投资者关系负责人',
        '22': 'SECRETARY',
        '23': u'投资者关系联系电话',
        '24': u'投资者关系联系邮箱',
        '25': u'证券简称',
        '26': u'简称拼音',
        '27': u'被暂停上市日',
        '28': u'被终止上市日',
        '29': u'恢复上市申请日',
        '30': u'恢复上市日',
        '31': u'特别转让',
        '32': u'三板转让方式',
        '33': u'新增上证180',
        '34': u'新增深100',
        '35': u'新增样本股',
        '36': u'剔除上证180',
        '37': u'剔除深100',
        '38': u'剔除样本股',
        '39': u'港股法定股本',
        '40': u'港股票面值',
        '41': u'港股买卖单位',
        '42': u'港股财政年度',
        '43': u'香港上市板块',
        '44': u'证券代码',
        '45': u'英文简称',
        '46': 'Co-CEO',
        '47': 'Co-CFO',
        '48': 'Co-COO',
        '49': 'Co-Chairman',
    }
}

SecuritiesChangeValueMap = {
    'sec_uni_code': {
        'SQL': ('data_center', "select sec_uni_code from sec_basic_info where source_id=%s and status!='9' limit 1;", 0)
    },
    'change_type': {
        '01': u'存续终止日期',
        '03': u'份额结转方式',
        '04': u'基金保本期变动',
        '05': u'基金风格',
        '06': u'基金管理人',
        '02': u'分配原则',
        '07': u'基金简称',
        '08': u'基金经理',
        '09': u'基金类型',
        '10': u'基金全称',
        '11': u'基金投资类别',
        '13': u'基金性质',
        '14': u'拼音简称',
        '15': u'上市地点',
        '16': u'投资范围',
        '17': u'运作期变动',
        '18': u'转换比例',
        '99': u'其他',
        '19': u'交易场所',
    }
}

ETFSubRedemListValueMap = {
    'sec_uni_code': {
        'SQL': ('data_center', '''select sec_uni_code from sec_basic_info where source_id=%s and status!='9' and sec_type=1004003 and sec_small_type in(1004003002,1004003003) limit 1;''', 0)
    },
    'sub_redem_sec_type': {
        '1': '股票',
        '2': '债券',
        '3': '现金',
        '4': 'AU99.95合约',
        '5': 'AU99.99合约',
    }
}

ETFSRComponentsValueMap = {
    'fund_uni_code': {
        'SQL': ('data_center', '''select sec_uni_code from sec_basic_info where source_id=%s and status!='9' and sec_type=1004003 and sec_small_type in(1004003002,1004003003) limit 1;''', 0)
    },
    'sub_redem_sec_type': {
        '1': u'股票',
        '2': u'债券',
        '3': u'现金',
        '4': u'AU99.95合约',
        '5': u'AU99.99合约',
    }
}

FundAssetAllocationValueMap = {
    'sec_uni_code': {
        'SQL': ('data_center', '''select sec_uni_code from sec_basic_info where source_id=%s and status!='9' and sec_type=1004003 and sec_small_type in(1004003002,1004003003) limit 1;''', 0)
    }
}

FundInvestIndustryValueMap = {
    'sec_uni_code': {
        'SQL': ('data_center', '''select sec_uni_code from sec_basic_info where source_id=%s and status!='9' and sec_type=1004003 and sec_small_type in(1004003002,1004003003) limit 1;''', 0)
    },
    'indu_standard': {
        '2101':	1001001,
        '2202':	1001013,
    },
    'indu_published_code': {
        'ZA': 'A',
        'ZB': 'B',
        'ZC': 'C',
        'ZC0': 'C0',
        'ZC1': 'C1',
        'ZC2': 'C2',
        'ZC3': 'C3',
        'ZC4': 'C4',
        'ZC5': 'C5',
        'ZC6': 'C6',
        'ZC7': 'C7',
        'ZC8': 'C8',
        'ZC99': 'C99',
        'ZD': 'D',
        'ZE': 'E',
        'ZF': 'F',
        'ZG': 'G',
        'ZH': 'H',
        'ZI': 'I',
        'ZJ': 'J',
        'ZK': 'K',
        'ZL': 'L',
        'ZM': 'M',
        'ZZZ': 'TOT',
        'A': 'A',
        'B': 'B',
        'C': 'C',
        'D': 'D',
        'E': 'E',
        'F': 'F',
        'G': 'G',
        'H': 'H',
        'I': 'I',
        'J': 'J',
        'K': 'K',
        'L': 'L',
        'M': 'M',
        'N': 'N',
        'O': 'O',
        'P': 'P',
        'Q': 'Q',
        'R': 'R',
        'S': 'S',
    }
}

FundComHolderValueMap = {
    'org_uni_code': {
        'SQL': ('data_center', '''select com_uni_code from org_basic_info where source_id=%s and status!='9' limit 1;''', 0)
    }
}

FundCodeValueMap = {
    'map_type': {
        '5': 1914001,
        '14': 1914002,
        '15': 1914003,
        '16': 1914004,
        '17': 1914005,
        '18': 1914006,
        '19': 1914007,
        '22': 1914008,
        '24': 1914009,
        '25': 1914010,
        '40': 1914011,
        '47': 1914012,
        '48': 1914013,
        '50': 1914014,
        '61': 1914015,
        '64': 1914016,
        '65': 1914017,
        '68': 1914018,
        '69': 1914019,
        '7': 1914020,
        '8': 1914021,
        '9': 1914022,
    },
    'sec_uni_code': {
        'SQL': ('data_center', '''select sec_uni_code from sec_basic_info where source_id=%s and status!='9' and sec_type=1004003 and sec_small_type in(1004003002,1004003003) limit 1;''', 0)
    }
}

BondsSecuritiesValueMap = {
    'security_type': {
        '001001': 1003024,
        '001002': 1003002,
        '001003': 1003001,
        '001005': 1003003,
        '001006': 1003025,
        '001007': 1003004,
        '001018': 1003026,
        '001027': 1003027,
        '001028': 1003028,
        '001029': 1003029,
        '001030': 1003030,
        '001034': 1003031,
        '001035': 1003032,
        '001038': 1003033,
        '001039': 1003034,
        '001040': 1003035,
        '001044': 1003036,
        '001047': 1003037,
        '001048': 1003038,
        '001049': 1003039,
        '001050': 1003040,
        '001051': 1003041,
        '001052': 1003042,
        '001053': 1003043,
        '001054': 1003044,
        '001055': 1003045,
        '001059': 1003046,
        '002001': 1003005,
        '002002': 1003047,
    },
    'sec_small_type': {
        '401': 1004002036,
        '402': 1004002003,
        '403': 1004002026,
        '404': 1004002023,
        '405': 1004002037,
        '406': 1004002004,
        '407': 1004002038,
        '408': 1004002021,
        '409': 1004012,
        '410': 1004002028,
        '411': 1004002029,
        '412': 1004002039,
        '413': 1004002040,
        '499': 1004002041,
        '1501': 1004002045,
        '909': 1004002046,
    },
    'ipo_status': {
        '1': 1002007,
        '2': 1002006,
        '0': 1002003,
        '3': 1002013,
    },
    'currency_type': {
        'SQL': ('data_center', "select system_uni_code from system_const where fat_name='货币类型' and status!='9' and system_disc=%s limit 1;", 0)
    },
    'com_uni_code': {
        'SQL': ('data_center', "select com_uni_code from org_basic_info where source_id=%s and status!='9' limit 1;", 0)
    },
    'abc_code': {
        'SQL': ('funds', "select DSYMBOL from TQ_OA_STCORRCODE where SECODE=%s and SETYPE1=4 and CTYPE=3 limit 1;", '')
    }
}

FundHshkIndustryValueMap = {
    'sec_uni_code': {
        'SQL': ('data_center', '''select sec_uni_code from sec_basic_info where source_id=%s and status!='9' and sec_type=1004003 and sec_small_type in(1004003002,1004003003) limit 1;''', 0)
    },
    'indu_standard': {
        '2102':	1001007,
        '2212':	1001013,
    },
    'indu_published_code': {
        '10': '10',
        '15': '15',
        '20': '20',
        '25': '25',
        '30': '30',
        '35': '35',
        '40': '40',
        '45': '45',
        '50': '50',
        '55': '55',
        '60': '60',
        'ZZZ': 'TOT',
        'A': 'A',
        'B': 'B',
        'C': 'C',
        'D': 'D',
        'E': 'E',
        'F': 'F',
        'G': 'G',
        'H': 'H',
        'I': 'I',
        'J': 'J',
        'K': 'K',
        'L': 'L',
        'M': 'M',
        'N': 'N',
        'O': 'O',
        'P': 'P',
        'Q': 'Q',
        'R': 'R',
        'S': 'S',
    }
}

FundInvestStockValueMap = {
    'sec_uni_code': {
        'SQL': ('data_center', '''select sec_uni_code from sec_basic_info where source_id=%s and status!='9' and sec_type=1004003 and sec_small_type in(1004003002,1004003003) limit 1;''', 0)
    },
    'inv_sec_uni_code': {
        'SQL': ('data_center', '''select sec_uni_code from sec_basic_info where sec_type=1004001 and sec_small_type=1004001001 and status!='9' and sec_code=%s limit 1;''', 0)
    },
    'inv_sec_uni_code_hk': {
        'SQL': ('data_center', '''select sec_uni_code from sec_basic_info where sec_type=1004017 and status!='9' and sec_code=%s and sec_name=%s limit 1;''', 0)
    },
}

FundInvestBondsValueMap = {
    'sec_uni_code': {
        'SQL': ('data_center', '''select sec_uni_code from sec_basic_info where source_id=%s and status!='9' and sec_type=1004003 and sec_small_type in(1004003002,1004003003) limit 1;''', 0)
    },
    'inv_sec_uni_code': {
        'SQL': ('data_center', '''select sec_uni_code from sec_basic_info where sec_type=1004002 and source_id=%s and status!='9' limit 1;''', 0)
    },
    'inv_sec_code': {
        'SQL': ('data_center', '''select sec_code from sec_basic_info where sec_type=1004002 and source_id=%s and status!='9' limit 1;''', 0)
    },
    'inv_sec_type': {
        'SQL': ('data_center', '''select sec_small_type from sec_basic_info where sec_type=1004002 and source_id=%s and status!='9' limit 1;''', 0)
    }
}

FundInvestFundValueMap = {
    'sec_uni_code': {
        'SQL': ('data_center', '''select sec_uni_code from sec_basic_info where source_id=%s and status!='9' and sec_type=1004003 and sec_small_type in(1004003002,1004003003) limit 1;''', 0)
    },
    'inv_sec_uni_code': {
        'SQL': ('data_center', '''select sec_uni_code from sec_basic_info where sec_type=1004003 and sec_small_type in(1004003002,1004003003) and source_id=%s and status!='9' limit 1;''', 0)
    },
    'inv_sec_code': {
        'SQL': ('data_center', '''select sec_code from sec_basic_info where sec_type=1004003 and sec_small_type in(1004003002,1004003003) and source_id=%s and status!='9' limit 1;''', 0)
    },
    'inv_sec_type': {
        'SQL': ('data_center', '''select sec_small_type from sec_basic_info where sec_type=1004003 and sec_small_type in(1004003002,1004003003) and source_id=%s and status!='9' limit 1;''', 0)
    }
}

IntermediaryOrgValueMap = {
    'sec_uni_code': {
        'SQL': ('data_center', '''select sec_uni_code from sec_basic_info where source_id=%s and status!='9' and sec_type=1004003 and sec_small_type in(1004003002,1004003003) limit 1;''', 0)
    },
    'org_uni_code': {
        'SQL': ('data_center', '''select com_uni_code from org_basic_info where source_id=%s and status!='9' limit 1;''', 0)
    },
    'org_type': {
        '1': 1913001,
        '2': 1913002,
        '3': 1913003,
        '4': 1913004,
        '5': 1913005,
        '6': 1913006,
        '7': 1913007,
        '8': 1913008,
        '11': 1913009,
        '12': 1913010,
        '13': 1913011,
        '14': 1913012,
        '15': 1913013,
        '16': 1913014,
        '18': 1913015,
        '19': 1913016,
        '20': 1913017,
        '21': 1913018,
        '22': 1913019,
        '23': 1913020,
        '24': 1913021,
        '25': 1913022,
        '26': 1913023,
        '27': 1913024,
        '28': 1913025,
        '29': 1913026,
        '30': 1913027,
        '31': 1913028,
    }
}

FundPortfolioChangeValueMap = {
    'sec_uni_code': {
        'SQL': ('data_center', '''select sec_uni_code from sec_basic_info where source_id=%s and status!='9' and sec_type=1004003 and sec_small_type in(1004003002,1004003003) limit 1;''', 0)
    },
    'inv_sec_uni_code': {
        'SQL': ('data_center', '''select sec_uni_code from sec_basic_info where sec_type=1004001 and sec_code=%s and status!='9' limit 1;''', 0)
    },
}

FundPortfolioChangeQDIIValueMap = {
    'sec_uni_code': {
        'SQL': ('data_center', '''select sec_uni_code from sec_basic_info where source_id=%s and status!='9' and sec_type=1004003 and sec_small_type in(1004003002,1004003003) limit 1;''', 0)
    },
}

QDIIFundNationAllocationValueMap = {
    'sec_uni_code': {
        'SQL': ('data_center', '''select sec_uni_code from sec_basic_info where source_id=%s and status!='9' and sec_type=1004003 and sec_small_type in(1004003002,1004003003) limit 1;''', 0)
    },
    'country_code': {
        'AT': 'AT',
        'AU': 'AU',
        'BE': 'BE',
        'BM': 'BM',
        'BR': 'BR',
        'CA': 'CA',
        'CH': 'CH',
        'CL': 'CL',
        'CN': 'CN',
        'CZ': 'CZ',
        'DE': 'DE',
        'DK': 'DK',
        'ES': 'ES',
        'FI': 'FI',
        'FR': 'FR',
        'UK': 'GB',
        'GR': 'GR',
        'HK': 'HK',
        'ID': 'ID',
        'IE': 'IE',
        'IL': 'IL',
        'IN': 'IN',
        'IT': 'IT',
        'JP': 'JP',
        'KR': 'KR',
        'LONC': 'GB',
        'LU': 'LU',
        'MX': 'MX',
        'MY': 'MY',
        'NL': 'NL',
        'NO': 'NO',
        'NZ': 'NZ',
        'PH': 'PH',
        'PL': 'PL',
        'RU': 'RU',
        'SE': 'SE',
        'SG': 'SG',
        'TH': 'TH',
        'TR': 'TR',
        'TW': 'TW',
        'US': 'US',
        'ZA': 'ZA',
        'ZZZ': 'TOT',
        'PT': 'PT',
    }
}

QDIIFundInvestIndustryValueMap = {
    'sec_uni_code': {
        'SQL': ('data_center', '''select sec_uni_code from sec_basic_info where source_id=%s and status!='9' and sec_type=1004003 and sec_small_type in(1004003002,1004003003) limit 1;''', 0)
    },
    'indu_standard': {
        '562': 1001001,
        '563': 1001007,
        '564': 1001008,
    }
}

QDIIFundRatedBondValueMap = {
    'sec_uni_code': {
        'SQL': ('data_center', '''select sec_uni_code from sec_basic_info where source_id=%s and status!='9' and sec_type=1004003 and sec_small_type in(1004003002,1004003003) limit 1;''', 0)
    },
    'credit_rating_code': {
        '1101': 1915001,
        '1102': 1915002,
        '1103': 1915003,
        '1104': 1915004,
        '1105': 1915005,
        '1106': 1915006,
        '1107': 1915007,
        '1108': 1915008,
        '1109': 1915009,
        '1110': 1915010,
        '1111': 1915011,
        '1112': 1915012,
        '1113': 1915013,
        '1114': 1915014,
        '1115': 1915015,
        '1201': 1915016,
        '1202': 1915017,
        '1203': 1915018,
        '1204': 1915019,
        '1205': 1915020,
        '1301': 1915021,
        '1302': 1915022,
        '1303': 1915023,
        '1304': 1915024,
        '1206': 1915025,
        '1305': 1915026,
        '1306': 1915027,
        '1307': 1915028,
        '1308': 1915029,
        '1309': 1915030,
        '1310': 1915031,
        '1312': 1915032,
        '1313': 1915033,
        '1314': 1915034,
        '1315': 1915035,
    }
}

QDIIFundInvestDetailValueMap = {
    'sec_uni_code': {
        'SQL': ('data_center', '''select sec_uni_code from sec_basic_info where source_id=%s and status!='9' and sec_type=1004003 and sec_small_type in(1004003002,1004003003) limit 1;''', 0)
    },
    'inv_sec_type': {
        '1': 1004001,
        '2': 1004002,
        '3': 1004003,
    },
    'currency_type': {
        'CNY': 1011001,
        'HKD': 1011003,
        'USD': 1011002,
    },
}

FundShareChangeValueMap = {
    'sec_uni_code': {
        'SQL': ('data_center', '''select sec_uni_code from sec_basic_info where source_id=%s and status!='9' and sec_type=1004003 and sec_small_type in(1004003002,1004003003) limit 1;''', 0)
    },
    'report_type': {
        '1': 1015037001002,
        '2': 1015037001001,
        '3': 1015037002001,
        '4': 1015037002002,
        '5': 1015037002003,
        '6': 1015037002004,
        '7': 1015037000,
    }
}

MMFRMaturityValueMap = {
    'sec_uni_code': {
        'SQL': ('data_center', '''select sec_uni_code from sec_basic_info where source_id=%s and status!='9' and sec_type=1004003 and sec_small_type in(1004003002,1004003003) limit 1;''', 0)
    },
}

FundHolderInfoValueMap = {
    'sec_uni_code': {
        'SQL': ('data_center', '''select sec_uni_code from sec_basic_info where source_id=%s and status!='9' and sec_type=1004003 and sec_small_type in(1004003002,1004003003) limit 1;''', 0)
    },
}

FundTopTenHolderValueMap = {
    'sec_uni_code': {
        'SQL': ('data_center', '''select sec_uni_code from sec_basic_info where source_id=%s and status!='9' and sec_type=1004003 and sec_small_type in(1004003002,1004003003) limit 1;''', 0)
    },
    'holder_type': {
        '1': '1',
        '2': '1',
        '3': '1',
        '4': '2',
        '5': '1',
        '6': '1',
        '7': '1',
        '8': '1',
        '9': '1',
        '10': '1',
        '11': '1',
        '12': '1',
        '13': '1',
        '14': '1',
        '15': '1',
        '16': '1',
        '17': '1',
        '99': '1',
    }
}

FundTradingShareValueMap = {
    'sec_uni_code': {
        'SQL': ('data_center', '''select sec_uni_code from sec_basic_info where source_id=%s and status!='9' and sec_type=1004003 and sec_small_type in(1004003002,1004003003) limit 1;''', 0)
    },
}

MMFIndexBrepoValueMap = {
    'sec_uni_code': {
        'SQL': ('data_center', '''select sec_uni_code from sec_basic_info where source_id=%s and status!='9' and sec_type=1004003 and sec_small_type in(1004003002,1004003003) limit 1;''', 0)
    },
    'report_type': {
        '1': 1015037002001,
        '2': 1015037002002,
        '3': 1015037002003,
        '4': 1015037002004,
        '5': 1015037001002,
        '6': 1015037001001
    }
}

MMFIndexAssdevValueMap = {
    'sec_uni_code': {
        'SQL': ('data_center', '''select sec_uni_code from sec_basic_info where source_id=%s and status!='9' and sec_type=1004003 and sec_small_type in(1004003002,1004003003) limit 1;''', 0)
    },
    'report_type': {
        '1': 1015037002001,
        '2': 1015037002002,
        '3': 1015037002003,
        '4': 1015037002004,
        '5': 1015037001002,
        '6': 1015037001001
    }
}

MMFIndexCurAvgMMONFValueMap = {
    'sec_uni_code': {
        'SQL': ('data_center', '''select sec_uni_code from sec_basic_info where source_id=%s and status!='9' and sec_type=1004003 and sec_small_type in(1004003002,1004003003) limit 1;''', 0)
    },
}

FundStockTradingValueMap = {
    'sec_uni_code': {
        'SQL': ('data_center', '''select sec_uni_code from sec_basic_info where source_id=%s and status!='9' and sec_type=1004003 and sec_small_type in(1004003002,1004003003) limit 1;''', 0)
    },
}

FundTCSsionValueMap = {
    'sec_uni_code': {
        'SQL': ('data_center', '''select sec_uni_code from sec_basic_info where source_id=%s and status!='9' and sec_type=1004003 and sec_small_type in(1004003002,1004003003) limit 1;''', 0)
    },
    'broker_code': {
        'SQL': ('data_center', '''select com_uni_code from org_basic_info where source_id=%s and status!='9' limit 1;''', 0)
    }
}

FMFIndexValueMap = {
    'sec_uni_code': {
        'SQL': ('data_center', '''select sec_uni_code from sec_basic_info where source_id=%s and status!='9' and sec_type=1004003 and sec_small_type in(1004003002,1004003003) limit 1;''', 0)
    },
    'report_type': {
        '200112': 1916002,
        '200113': 1916003
    },
    'accounting_standard_code': {
        '2': 1502002,
    },
    'accounting_standard_name': {
        u'新会计准则': u'07年新会计准则'
    },
    'currency_type': {
        'SQL': ('data_center', "select system_uni_code from system_const where fat_name='货币类型' and status!='9' and system_disc=%s limit 1;", 0)
    },
}

FundBalanceSheetValueMap = {
    'sec_uni_code': {
        'SQL': ('data_center', '''select sec_uni_code from sec_basic_info where source_id=%s and status!='9' and sec_type=1004003 and sec_small_type in(1004003002,1004003003) limit 1;''', 0)
    },
    'accounting_standard_code': {
        '1': 1502001,
        '2': 1502002,
    },
    'accounting_standard_name': {
        u'旧会计准则': u'旧准则',
        u'新会计准则': u'07年新会计准则',
    },
    'currency_type': {
        'SQL': ('data_center', "select system_uni_code from system_const where fat_name='货币类型' and status!='9' and system_disc=%s limit 1;", 0)
    },
}

FundBalanceSheetNewValueMap = {
    'sec_uni_code': {
        'SQL': ('data_center', '''select sec_uni_code from sec_basic_info where source_id=%s and status!='9' and sec_type=1004003 and sec_small_type in(1004003002,1004003003) limit 1;''', 0)
    },
    'report_type': {
        '200111': 1916001,
        '200112': 1916002,
        '200113': 1916003,
    },
    'accounting_standard_code': {
        '1': 1502001,
        '2': 1502002,
    },
    'accounting_standard_name': {
        u'旧会计准则': u'旧准则',
        u'新会计准则': u'07年新会计准则',
    },
    'currency_type': {
        'SQL': ('data_center', "select system_uni_code from system_const where fat_name='货币类型' and status!='9' and system_disc=%s limit 1;", 0)
    },
}

FundIncomeStatementValueMap = {
    'sec_uni_code': {
        'SQL': ('data_center', '''select sec_uni_code from sec_basic_info where source_id=%s and status!='9' and sec_type=1004003 and sec_small_type in(1004003002,1004003003) limit 1;''', 0)
    },
    'report_type': {
        '200111': 1916001,
        '200112': 1916002,
        '200113': 1916003,
    },
    'accounting_standard_code': {
        '1': 1502001,
        '2': 1502002,
    },
    'accounting_standard_name': {
        u'旧会计准则': u'旧准则',
        u'新会计准则': u'07年新会计准则',
    },
    'currency_type': {
        'SQL': ('data_center', "select system_uni_code from system_const where fat_name='货币类型' and status!='9' and system_disc=%s limit 1;", 0)
    },
}

FundIncomeStatementNewValueMap = {
    'sec_uni_code': {
        'SQL': ('data_center', '''select sec_uni_code from sec_basic_info where source_id=%s and status!='9' and sec_type=1004003 and sec_small_type in(1004003002,1004003003) limit 1;''', 0)
    },
    'report_type': {
        '200111': 1916001,
        '200112': 1916002,
        '200113': 1916003,
    },
    'accounting_standard_code': {
        '1': 1502001,
        '2': 1502002,
    },
    'accounting_standard_name': {
        u'旧会计准则': u'旧准则',
        u'新会计准则': u'07年新会计准则',
    },
    'currency_type': {
        'SQL': ('data_center', "select system_uni_code from system_const where fat_name='货币类型' and status!='9' and system_disc=%s limit 1;", 0)
    },
}

FundNavChangeValueMap = {
    'sec_uni_code': {
        'SQL': ('data_center', '''select sec_uni_code from sec_basic_info where source_id=%s and status!='9' and sec_type=1004003 and sec_small_type in(1004003002,1004003003) limit 1;''', 0)
    },
    'report_type': {
        '200111': 1916001,
        '200112': 1916002,
        '200113': 1916003,
    },
    'accounting_standard_code': {
        '1': 1502001,
        '2': 1502002,
    },
    'accounting_standard_name': {
        u'旧会计准则': u'旧准则',
        u'新会计准则': u'07年新会计准则',
    },
    'currency_type': {
        'SQL': ('data_center', "select system_uni_code from system_const where fat_name='货币类型' and status!='9' and system_disc=%s limit 1;", 0)
    },
}

FundNavChangeNewValueMap = {
    'sec_uni_code': {
        'SQL': ('data_center', '''select sec_uni_code from sec_basic_info where source_id=%s and status!='9' and sec_type=1004003 and sec_small_type in(1004003002,1004003003) limit 1;''', 0)
    },
    'report_type': {
        '200112': 1916002,
    },
    'accounting_standard_code': {
        '1': 1502001,
        '2': 1502002,
    },
    'accounting_standard_name': {
        u'旧会计准则': u'旧准则',
        u'新会计准则': u'07年新会计准则',
    },
    'currency_type': {
        'SQL': ('data_center', "select system_uni_code from system_const where fat_name='货币类型' and status!='9' and system_disc=%s limit 1;", 0)
    },
    'project_code': {
        '10': 1917001,
        '20': 1917002,
        '30': 1917003,
        '31': 1917004,
        '32': 1917005,
        '40': 1917006,
        '50': 1917007,
    }
}

FundProfitDistValueMap = {
    'sec_uni_code': {
        'SQL': ('data_center', '''select sec_uni_code from sec_basic_info where source_id=%s and status!='9' and sec_type=1004003 and sec_small_type in(1004003002,1004003003) limit 1;''', 0)
    },
}

FundUndistProfitNewValueMap = {
    'sec_uni_code': {
        'SQL': ('data_center', '''select sec_uni_code from sec_basic_info where source_id=%s and status!='9' and sec_type=1004003 and sec_small_type in(1004003002,1004003003) limit 1;''', 0)
    },
    'report_type': {
        '200112': 1916002,
    },
    'accounting_standard_code': {
        '1': 1502001,
        '2': 1502002,
    },
    'accounting_standard_name': {
        u'旧会计准则': u'旧准则',
        u'新会计准则': u'07年新会计准则',
    },
    'currency_type': {
        'SQL': ('data_center', "select system_uni_code from system_const where fat_name='货币类型' and status!='9' and system_disc=%s limit 1;", 0)
    },
    'project_code': {
        '10': 1918001,
        '20': 1918002,
        '30': 1918003,
        '31': 1918004,
        '32': 1918005,
        '40': 1918006,
        '50': 1918007,
    }
}

FundFinancialNoteValueMap = {
    'sec_uni_code': {
        'SQL': ('data_center', '''select sec_uni_code from sec_basic_info where source_id=%s and status!='9' and sec_type=1004003 and sec_small_type in(1004003002,1004003003) limit 1;''', 0)
    },
    'report_type': {
        '11': 1916001,
        '12': 1916002,
    },
    'currency_type': {
        'SQL': ('data_center', "select system_uni_code from system_const where fat_name='货币类型' and status!='9' and system_disc=%s limit 1;", 0)
    },
    'unit': {
        '1': 1919001,
        '2': 1919002,
        '3': 1919003,
        '4': 1919004,
    },
    'subject_type': {
        '10': 1920001,
        '11': 1920002,
        '12': 1920003,
        '13': 1920004,
    },
    'subject_code': {
        '1001': 1920001001,
        '1002': 1920001002,
        '1003': 1920001003,
        '1004': 1920001004,
        '1005': 1920001005,
        '1006': 1920001006,
        '1007': 1920001007,
        '1008': 1920001008,
        '1009': 1920001009,
        '1101': 1920002001,
        '1102': 1920002002,
        '1103': 1920002003,
        '1104': 1920002004,
        '1105': 1920002005,
        '1106': 1920002006,
        '1107': 1920002007,
        '1108': 1920002008,
        '1109': 1920002009,
        '1110': 1920002010,
        '1111': 1920002011,
        '1112': 1920002012,
        '1113': 1920002013,
        '1114': 1920002014,
        '1201': 1920003001,
        '1202': 1920003002,
        '1203': 1920003003,
        '1204': 1920003004,
        '1205': 1920003005,
        '1301': 1920004001,
        '1302': 1920004002,
        '1303': 1920004003,
        '1304': 1920004004,
        '1305': 1920004005,
        '1306': 1920004006,
        '1307': 1920004007,
        '1308': 1920004008,
        '1309': 1920004009,
        '1310': 1920004010,
        '1311': 1920004011,
        '1312': 1920004012,
        '1313': 1920004013,
        '1314': 1920004014,
    }
}

FundSplitConversionValueMap = {
    'sec_uni_code': {
        'SQL': ('data_center', '''select sec_uni_code from sec_basic_info where source_id=%s and status!='9' and sec_type=1004003 and sec_small_type in(1004003002,1004003003) limit 1;''', 0)
    },
    'currency_type': {
        'SQL': ('data_center', "select system_uni_code from system_const where fat_name='货币类型' and status!='9' and system_disc=%s limit 1;", 0)
    },
    'split_conversion_type': {
        '1': 1923001,
        '2': 1923002,
        '3': 1923003,
        '4': 1923004,
        '5': 1923005,
    },
    'split_conversion_status': {
        1: 1911001,
        2: 1911002,
    },
}

StructFundBasicValueMap = {
    'sec_uni_code': {
        'SQL': ('data_center', '''select sec_uni_code from sec_basic_info where source_id=%s and status!='9' and sec_type=1004003 and sec_small_type in(1004003002,1004003003) limit 1;''', 0)
    },
    'fund_main_code': {
        'SQL': ('data_center', '''select sec_uni_code from sec_basic_info where source_id=%s and status!='9' and sec_type=1004003 and sec_small_type in(1004003002,1004003003) limit 1;''', 0)
    },
    'share_type': {
        '1': 1921001,
        '2': 1921002,
        '3': 1921003,
    },
    'regular_convert_cycle_unit': {
        1: 1524006,
        2: 1524008,
        None: None,
    }
}

StructFundPreReturnValueMap = {
    'sec_uni_code': {
        'SQL': ('data_center', '''select sec_uni_code from sec_basic_info where source_id=%s and status!='9' and sec_type=1004003 and sec_small_type in(1004003002,1004003003) limit 1;''', 0)
    },
    'calc_type': {
        '1': 1922001,
        '2': 1922002,
    },
    'interest_type': {
        '1': 1016001,
        '2': 1016002,
        None: None,
    },
    'change_frequency': {
        '1': u'会计年度',
        '2': u'运作年度',
        '3': u'3个月',
        '4': u'6个月',
        '5': u'1年',
        '6': u'2年',
        '7': u'3年',
        '8': u'5年',
        '9': u'4个月',
        None: None,
    },
    'is_taxed': {
        '1': u'税后',
        '2': u'税前',
        '9': u'无',
        None: None,
    }
}

StructFundShareMatchValueMap = {
    'sec_uni_code': {
        'SQL': ('data_center', '''select sec_uni_code from sec_basic_info where source_id=%s and status!='9' and sec_type=1004003 and sec_small_type in(1004003002,1004003003) limit 1;''', 0)
    },
    'priority_sec_uni_code': {
        'SQL': ('data_center', '''select sec_uni_code from sec_basic_info where source_id=%s and status!='9' and sec_type=1004003 and sec_small_type in(1004003002,1004003003) limit 1;''', 0)
    },
    'general_sec_uni_code': {
        'SQL': ('data_center', '''select sec_uni_code from sec_basic_info where source_id=%s and status!='9' and sec_type=1004003 and sec_small_type in(1004003002,1004003003) limit 1;''', 0)
    },
}

StructFundThresholdValueMap = {
    'sec_uni_code': {
        'SQL': ('data_center', '''select sec_uni_code from sec_basic_info where source_id=%s and status!='9' and sec_type=1004003 and sec_small_type in(1004003002,1004003003) limit 1;''', 0)
    },
    'multiple_fund_uni_code': {
        'SQL': ('data_center', '''select sec_uni_code from sec_basic_info where source_id=%s and status!='9' and sec_type=1004003 and sec_small_type in(1004003002,1004003003) limit 1;''', None)
    },
    'currency_type': {
        'SQL': ('data_center', '''select system_uni_code from system_const where fat_name='货币类型' and status!='9' and system_disc=%s limit 1;''', 0)
    },
    'relationship_type': {
        '1': u'常量',
        '2': u'倍数',
    }
}

FundSRStatusValueMap = {
    'sec_uni_code': {
        'SQL': ('data_center', '''select sec_uni_code from sec_basic_info where source_id=%s and status!='9' and sec_type=1004003 and sec_small_type in(1004003002,1004003003) limit 1;''', 0)
    },
    'sub_redem_status': {
        '01': 1924001,
        '02': 1924002,
        '03': 1924003,
        '04': 1924004,
        '05': 1924005,
        '06': 1924006,
        '07': 1924007,
        '08': 1924008,
        '09': 1924009,
        '10': 1924010,
        '11': 1924011,
        '12': 1924012,
        '13': 1924013,
        '14': 1924014,
        '15': 1924015,
        '16': 1924016,
        '17': 1924017,
        '18': 1924018,
        '19': 1924019,
        '20': 1924020,
        '21': 1924021,
        '22': 1924022,
        '23': 1924023,
        '24': 1924024,
        '25': 1924025,
        '26': 1924026,
        '27': 1924027,
        '28': 1924028,
        '29': 1924029,
        '30': 1924030,
        '31': 1924031,
        '32': 1924032,
        '33': 1924033,
        '34': 1924034,
        '35': 1924035,
        '36': 1924036,
        '37': 1924037,
        '38': 1924038,
        '39': 1924039,
        '40': 1924040,
        '41': 1924041,
        '42': 1924042,
        '43': 1924043,
        '44': 1924044,
        '45': 1924045,
        '46': 1924046,
        '47': 1924047,
        '48': 1924048,
        '49': 1924049,
        '50': 1924050,
        '51': 1924051,
        '52': 1924052,
        '53': 1924053,
        '54': 1924054,
        '55': 1924055,
        '56': 1924056,
        '57': 1924057,
        '58': 1924058,
        '59': 1924059,
        '60': 1924060,
        '61': 1924061,
        '62': 1924062,
        '63': 1924063,
        '64': 1924064,
        '65': 1924065,
        '66': 1924066,
        '67': 1924067,
        '68': 1924068,
        '69': 1924069,
        '70': 1924070,
        '71': 1924071,
        '72': 1924072,
        '73': 1924073,
        '74': 1924074,
        '999': 1924075,
    }
}

FundPrizeValueMap = {
    'prize_code': {
        '02002': 1925001002,
        '02003': 1925001003,
        '02004': 1925001004,
        '02005': 1925001005,
        '02006': 1925001006,
        '02007': 1925001007,
        '02008': 1925001008,
        '02009': 1925001009,
        '02010': 1925001010,
        '02011': 1925001011,
        '02012': 1925001012,
        '02013': 1925001013,
        '02017': 1925001014,
        '02018': 1925001015,
        '02019': 1925001016,
        '02020': 1925001017,
        '02021': 1925001018,
        '02022': 1925001019,
        '02023': 1925001020,
        '02024': 1925001021,
        '02025': 1925001022,
        '02026': 1925001023,
        '02027': 1925001024,
        '02028': 1925001025,
        '02029': 1925001026,
        '02030': 1925001027,
        '02031': 1925001028,
        '02032': 1925001029,
        '02033': 1925001030,
        '02034': 1925001031,
        '02035': 1925001032,
        '02036': 1925001033,
        '02037': 1925001034,
        '02038': 1925001035,
        '02039': 1925001036,
        '02040': 1925001037,
        '02041': 1925001038,
        '02042': 1925001039,
        '02053': 1925001040,
        '02054': 1925001041,
        '02055': 1925001042,
        '02056': 1925001043,
        '02057': 1925001044,
        '02058': 1925001045,
        '02059': 1925001046,
        '01001': 1925002001,
        '01004': 1925002002,
        '01005': 1925002003,
        '01037': 1925002004,
        '01038': 1925002005,
        '01040': 1925002006,
        '01039': 1925002007,
        '01041': 1925002008,
        '01036': 1925002009,
        '01002': 1925002010,
        '01003': 1925002011,
        '01006': 1925002012,
        '01007': 1925002013,
        '01009': 1925002014,
        '01010': 1925002015,
        '01012': 1925002016,
        '01008': 1925002017,
        '01011': 1925002018,
        '01013': 1925002019,
        '01014': 1925002020,
        '01018': 1925002021,
        '01015': 1925002022,
        '01019': 1925002023,
        '01016': 1925002024,
        '01020': 1925002025,
        '01017': 1925002026,
        '01046': 1925002027,
        '01047': 1925002028,
        '01050': 1925002029,
        '01048': 1925002030,
        '01044': 1925002031,
        '01045': 1925002032,
        '01043': 1925002033,
        '01049': 1925002034,
        '01042': 1925002035,
        '01055': 1925002036,
        '01056': 1925002037,
        '01057': 1925002038,
        '01054': 1925002039,
        '01053': 1925002040,
        '01058': 1925002041,
        '01052': 1925002042,
        '01051': 1925002043,
        '01062': 1925002044,
        '03003': 1925003001,
        '03006': 1925003002,
        '03001': 1925003003,
        '03010': 1925003004,
        '03008': 1925003005,
        '03007': 1925003006,
        '03004': 1925003007,
        '03009': 1925003008,
        '03011': 1925003009,
        '03012': 1925003010,
        '03013': 1925003011,
        '03019': 1925003012,
        '03014': 1925003013,
        '03024': 1925003014,
        '03025': 1925003015,
        '03026': 1925003016,
        '03052': 1925003017,
        '03057': 1925003018,
        '03058': 1925003019,
        '03064': 1925003020,
        '03066': 1925003021,
        '03063': 1925003022,
        '03002': 1925003023,
        '03005': 1925003024,
        '03016': 1925003025,
        '03017': 1925003026,
        '03015': 1925003027,
        '03020': 1925003028,
        '03021': 1925003029,
        '03018': 1925003030,
        '03022': 1925003031,
        '03027': 1925003032,
        '03028': 1925003033,
        '03032': 1925003034,
        '03029': 1925003035,
        '03033': 1925003036,
        '03035': 1925003037,
        '03034': 1925003038,
        '03036': 1925003039,
        '03037': 1925003040,
        '03038': 1925003041,
        '03059': 1925003042,
        '03060': 1925003043,
        '03065': 1925003044,
        '03108': 1925003045,
        '03109': 1925003046,
        '03106': 1925003047,
        '03105': 1925003048,
        '03107': 1925003049,
        '03110': 1925003050,
        '03104': 1925003051,
        '03101': 1925003052,
        '03197': 1925003053,
        '03102': 1925003054,
        '03103': 1925003055,
        '03199': 1925003056,
        '03198': 1925003057,
        '03100': 1925003058,
        '02060': 1925003059,
        '07002': 1925004001,
        '07003': 1925004002,
        '07004': 1925004003,
        '07005': 1925004004,
        '07006': 1925004005,
        '07007': 1925004006,
        '07008': 1925004007,
        '07009': 1925004008,
        '07010': 1925004009,
        '07011': 1925004010,
        '07014': 1925004011,
        '07015': 1925004012,
        '07016': 1925004013,
        '07017': 1925004014,
        '07018': 1925004015,
        '07019': 1925004016,
    },
    'sponsor_code': {
        'SQL': ('data_center', '''select com_uni_code from org_basic_info where source_id=%s and status!='9' limit 1;''', None)
    }
}

FundISplitConversionValueMap = {
    'sec_uni_code': {
        'SQL': ('data_center', '''select sec_uni_code from sec_basic_info where source_id=%s and status!='9' and sec_type=1004003 and sec_small_type in(1004003002,1004003003) limit 1;''', 0)
    },
    'send_sec_uni_code': {
        'SQL': ('data_center', '''select sec_uni_code from sec_basic_info where source_id=%s and status!='9' and sec_type=1004003 and sec_small_type in(1004003002,1004003003) limit 1;''', 0)
    },
    'split_conversion_type': {
        '1': 1923005001,
        '2': 1923005002,
    }
}

FundMangerInfoValueMap = {
    'org_uni_code': {
        'SQL': ('data_center', '''select com_uni_code from org_basic_info where source_id=%s and status!='9' limit 1;''', 0)
    },
    'peo_uni_code': {
        'SQL': ('data_center', '''select peo_uni_code from peo_basic_info where source_id=%s and status!='9' limit 1;''', None)
    },
    'post': {
        '01': 151000102,
        '02': 151000107,
        '03': 151000137,
        '04': 151000106,
        '05': 151000169,
        '06': 151000124,
        '07': 151000136,
        '08': 151000126,
        '09': 151000125,
        '10': 151000170,
        '11': 151000104,
        '12': 151000127,
        '13': 151000117,
        '14': 151000171,
        '15': 151000115,
        '16': 151000133,
        '17': 151000172,
        '18': 151000173,
        '19': 151000132,
        '20': 151000118,
        '21': 151000158,
        '22': 151000174,
        '23': 1012005,
        '24': 151000129,
        '25': 151000175,
        '26': 151000178,
        '27': 151000103,
        '28': 151000101,
        '29': 151000176,
        '30': 151000177,
        '31': 151000140,
    },
    'sex_par': {
        u'男': 0,
        u'女': 1,
    },
    'high_edu': {
        '7': 1010002,
        '6': 1010003,
        '5': 1010004,
        '4': 1010005,
        '3': 1010006,
        '2': 1010007,
        '1': 1010008,
    }
}

FundCloseOpenValueMap = {
    'cfund_uni_code': {
        'SQL': ('data_center', '''select sec_uni_code from sec_basic_info where source_id=%s and status!='9' and sec_type=1004003 and sec_small_type in(1004003002,1004003003) limit 1;''', 0)
    },
    'ofund_uni_code': {
        'SQL': ('data_center', '''select sec_uni_code from sec_basic_info where source_id=%s and status!='9' and sec_type=1004003 and sec_small_type in(1004003002,1004003003) limit 1;''', 0)
    },
}

FundInherentInvestValueMap = {
    'sec_uni_code': {
        'SQL': ('data_center', '''select sec_uni_code from sec_basic_info where source_id=%s and status!='9' and sec_type=1004003 and sec_small_type in(1004003002,1004003003) limit 1;''', 0)
    },
    'mana_comp_uni_code': {
        'SQL': ('data_center', '''select com_uni_code from org_basic_info where source_id=%s and status!='9' limit 1;''', None)
    },
    'invest_type': {
        '11': 1926001,
        '12': 1926002,
        '21': 1926003,
        '22': 1926004,
        '31': 1926005,
        '32': 1926006,
        '41': 1926007,
        '42': 1926008,
        '51': 1926009,
        '52': 1926010,
    },
    'app_rate_unit': {
        '1': 1907005001,
        '2': 1907005003,
        None: None,
    }
}

FundHolderMeetingValueMap = {
    'sec_uni_code': {
        'SQL': ('data_center', '''select sec_uni_code from sec_basic_info where source_id=%s and status!='9' and sec_type=1004003 and sec_small_type in(1004003002,1004003003) limit 1;''', 0)
    },
    'meeting_type': {
        '01': 1017001,
        '02': 1017002,
        '03': 1017003,
    },
    'convening_form': {
        '01': 1018001,
        '02': 1018002,
        '99': 1018003,
    }
}

FundPPQualificationValueMap = {
    'org_uni_code': {
        'SQL': ('data_center', "select com_uni_code from org_basic_info where source_id=%s and status!='9' limit 1;", 0)
    },
    'org_type': {
        1: 1927001,
        2: 1927002,
        3: 1927003,
        4: 1927004,
    },
}

FundXRFactorValueMap = {
    'sec_uni_code': {
        'SQL': ('data_center', '''select sec_uni_code from sec_basic_info where source_id=%s and status!='9' and sec_type=1004003 and sec_small_type in(1004003002,1004003003) limit 1;''', 0)
    },
    'currency_type': {
        'SQL': ('data_center', "select system_uni_code from system_const where fat_name='货币类型' and status!='9' and system_disc=%s limit 1;", None)
    },
    'bonus_type': {
        '1': 1928001,
        '4': 1928002,
        '5': 1928003,
        '8': 1928004,
    }
}

FundMarketScaleValueMap = {
    'fund_type': {
        '1310': u'合计',
        '1311': u'封闭式基金',
        '1312': u'开放式基金',
        '131201': u'股票基金',
        '131202': u'混合基金',
        '131203': u'债券基金',
        '131204': u'货币基金',
        '131205': u'QDII基金',
    }
}

FundKeeperFundValueMap = {
    'fund_keeper_code': {
        'SQL': ('data_center', "select com_uni_code from org_basic_info where source_id=%s and status!='9' limit 1;", None)
    }
}

FundSDRateValueMap = {
    'sec_uni_code': {
        'SQL': ('data_center', '''select sec_uni_code from sec_basic_info where source_id=%s and status!='9' and sec_type=1004003 and status!='9' and sec_small_type in(1004003002,1004003003) limit 1;''', 0)
    },
}

FundSIHShareValueMap = {
    'sec_uni_code': {
        'SQL': ('data_center', '''select sec_uni_code from sec_basic_info where source_id=%s and status!='9' and sec_type=1004003 and status!='9' and sec_small_type in(1004003002,1004003003) limit 1;''', 0)
    },
    'report_type': {
        '1': 1015037002001,
        '2': 1015037002002,
        '3': 1015037002003,
        '4': 1015037002004,
        '5': 1015037001002,
        '6': 1015037001001,
    },
    'investor_type': {
        '1': u'机构',
        '2': u'个人',
        '3': u'ETF联接基金',
        '9': u'其他',
    }
}

FundLeverageValueMap = {
    'sec_uni_code': {
        'SQL': ('data_center', '''select sec_uni_code from sec_basic_info where source_id=%s and status!='9' and sec_type=1004003 and status!='9' and sec_small_type in(1004003002,1004003003) limit 1;''', 0)
    },
}

BondsSecuritiesRepurValueMap = {
    'currency_type': {
        'SQL': ('data_center', "select system_uni_code from system_const where fat_name='货币类型' and status!='9' and system_disc=%s limit 1;", 0)
    },
    'com_uni_code': {
        'SQL': ('data_center', "select com_uni_code from org_basic_info where source_id=%s and status!='9' limit 1;", None)
    },
    'sec_small_type': {
        '811': 1004007002,
        '812': 1004007001,
    },
    'ipo_status': {
        '1': 1002007,
        '2': 1002006,
        '0': 1002003,
        '3': 1002013,
    },
    'security_type': {
        '001002': 1003002,
        '001003': 1003001,
        '001005': 1003003,
        '001006': 1003025,
    },
}

FundTrusteeValueMap = {
    'fund_trustee_code': {
        'SQL': ('data_center', "select com_uni_code from org_basic_info where source_id=%s and status!='9' limit 1;", None)
    },
}

FundDiscountValueMap = {
    'sec_uni_code': {
        'SQL': ('data_center', '''select sec_uni_code from sec_basic_info where source_id=%s and status!='9' and sec_type=1004003 and status!='9' and sec_small_type in(1004003002,1004003003) limit 1;''', 0)
    },
}

FundMangerStatValueMap = {
    'peo_uni_code': {
        'SQL': ('data_center', '''select peo_uni_code from peo_basic_info where peo_uni_code>0 and come_source='zh-data' and status!='9' and source_id=%s limit 1;''', None)
    },
    'present_comp_code': {
        'SQL': ('data_center', "select com_uni_code from org_basic_info where org_uni_code>0 and org_name=%s and status!='9' limit 1;", None)
    }
}

FundMangerPrefValueMap = {
    'sec_uni_code': {
        'SQL': ('data_center', '''select sec_uni_code from sec_basic_info where source_id=%s and status!='9' and sec_type=1004003 and status!='9' and sec_small_type in(1004003002,1004003003) limit 1;''', 0)
    },
    'peo_uni_code': {
        'SQL': ('data_center', '''select peo_uni_code from peo_basic_info where peo_uni_code>0 and come_source='zh-data' and status!='9' and source_id=%s limit 1;''', None)
    },
    'fund_type': {
        '100101': u'股票型基金',
        '100201': u'混合型基金',
        '100301': u'债券型基金',
        '100401': u'货币式基金',
        '100501': u'QDII基金',
        '100601': u'商品型基金',
    }
}

FundNavReturnValueMap = {
    'sec_uni_code': {
        'SQL': ('data_center', '''select sec_uni_code from sec_basic_info where source_id=%s and status!='9' and sec_type=1004003 and status!='9' and sec_small_type in(1004003002,1004003003) limit 1;''', 0)
    },
    'currency_type': {
        'SQL': ('data_center', "select system_uni_code from system_const where fat_name='货币类型' and status!='9' and system_disc=%s limit 1;", None)
    }
}

FundBenchmarkYieldValueMap = {
    'sec_uni_code': {
        'SQL': ('data_center', '''select sec_uni_code from sec_basic_info where sec_uni_code>0 and source_id=%s and status!='9' and sec_type=1004003 and status!='9' and sec_small_type in(1004003002,1004003003) limit 1;''', 0)
    },
}